eTRM uses javascript that opens and focuses a separate window to display reports. Your browser does not appear to support javascript. This should not prevent you from using eTRM but it does mean the window focus feature will not work. Please check the contents of other windows on your desktop if you click on a link that does not appear to do anything.

DBA Data [Home] [Help] [Dependency Information]

VIEW: SYS.V_$SESSION_LONGOPS

Object Details

Object Name:	V_$SESSION_LONGOPS
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
SID	NUMBER
SERIAL#	NUMBER
OPNAME	VARCHAR2	(64)
TARGET	VARCHAR2	(64)
TARGET_DESC	VARCHAR2	(32)
SOFAR	NUMBER
TOTALWORK	NUMBER
UNITS	VARCHAR2	(32)
START_TIME	DATE
LAST_UPDATE_TIME	DATE
TIMESTAMP	DATE
TIME_REMAINING	NUMBER
ELAPSED_SECONDS	NUMBER
CONTEXT	NUMBER
MESSAGE	VARCHAR2	(512)
USERNAME	VARCHAR2	(30)
SQL_ADDRESS	RAW	(8)
SQL_HASH_VALUE	NUMBER
SQL_ID	VARCHAR2	(13)
SQL_PLAN_HASH_VALUE	NUMBER
SQL_EXEC_START	DATE
SQL_EXEC_ID	NUMBER
SQL_PLAN_LINE_ID	NUMBER
SQL_PLAN_OPERATION	VARCHAR2	(30)
SQL_PLAN_OPTIONS	VARCHAR2	(30)
QCSID	NUMBER
CON_ID	NUMBER

Query Text

Cut, paste (and edit) the following text to query this object:


SELECT SID
,      SERIAL#
,      OPNAME
,      TARGET
,      TARGET_DESC
,      SOFAR
,      TOTALWORK
,      UNITS
,      START_TIME
,      LAST_UPDATE_TIME
,      TIMESTAMP
,      TIME_REMAINING
,      ELAPSED_SECONDS
,      CONTEXT
,      MESSAGE
,      USERNAME
,      SQL_ADDRESS
,      SQL_HASH_VALUE
,      SQL_ID
,      SQL_PLAN_HASH_VALUE
,      SQL_EXEC_START
,      SQL_EXEC_ID
,      SQL_PLAN_LINE_ID
,      SQL_PLAN_OPERATION
,      SQL_PLAN_OPTIONS
,      QCSID
,      CON_ID
FROM SYS.V_$SESSION_LONGOPS;

Dependencies

[top of page]

SYS.V_$SESSION_LONGOPS references the following:

SYS.V_$SESSION_LONGOPS is referenced by following:

PUBLIC: V$SESSION_LONGOPS