[Home] [Help] [Dependency Information]
Object Name: | V_$SQL_WORKAREA_ACTIVE |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
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 |
Cut, paste (and edit) the following text to query this object:
SELECT 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.V_$SQL_WORKAREA_ACTIVE;
|
|
|