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.GV_$SQL_WORKAREA_ACTIVE

Object Details

Object Name:	GV_$SQL_WORKAREA_ACTIVE
Object Type:	VIEW
Owner:	SYS
Subobject Name:
Status:	VALID

[View Source]

Columns

Name	Datatype	Length
INST_ID	NUMBER
SQL_HASH_VALUE	NUMBER
SQL_ID	VARCHAR2	(13)
SQL_EXEC_START	DATE
SQL_EXEC_ID	NUMBER
WORKAREA_ADDRESS	RAW	(8)
OPERATION_TYPE	VARCHAR2	(40)
OPERATION_ID	NUMBER
POLICY	VARCHAR2	(6)
SID	NUMBER
QCINST_ID	NUMBER
QCSID	NUMBER
ACTIVE_TIME	NUMBER
WORK_AREA_SIZE	NUMBER
EXPECTED_SIZE	NUMBER
ACTUAL_MEM_USED	NUMBER
MAX_MEM_USED	NUMBER
NUMBER_PASSES	NUMBER
TEMPSEG_SIZE	NUMBER
TABLESPACE	VARCHAR2	(30)
SEGRFNO#	NUMBER
SEGBLK#	NUMBER
CON_ID	NUMBER

Query Text

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


SELECT INST_ID
,      SQL_HASH_VALUE
,      SQL_ID
,      SQL_EXEC_START
,      SQL_EXEC_ID
,      WORKAREA_ADDRESS
,      OPERATION_TYPE
,      OPERATION_ID
,      POLICY
,      SID
,      QCINST_ID
,      QCSID
,      ACTIVE_TIME
,      WORK_AREA_SIZE
,      EXPECTED_SIZE
,      ACTUAL_MEM_USED
,      MAX_MEM_USED
,      NUMBER_PASSES
,      TEMPSEG_SIZE
,      TABLESPACE
,      SEGRFNO#
,      SEGBLK#
,      CON_ID
FROM SYS.GV_$SQL_WORKAREA_ACTIVE;

Dependencies

[top of page]

SYS.GV_$SQL_WORKAREA_ACTIVE references the following:

SYS.GV_$SQL_WORKAREA_ACTIVE is referenced by following:

PUBLIC: GV$SQL_WORKAREA_ACTIVE