[Home] [Help] [Dependency Information]
Object Name: | GV_$SQL_CURSOR |
---|---|
Object Type: | VIEW |
Owner: | SYS |
Subobject Name: | |
Status: | VALID |
Name | Datatype | Length | Mandatory | Comments |
---|---|---|---|---|
INST_ID | NUMBER | |||
CURNO | NUMBER | |||
FLAG | NUMBER | |||
STATUS | VARCHAR2 | (9) | ||
PARENT_HANDLE | RAW | (8) | ||
PARENT_LOCK | RAW | (8) | ||
CHILD_LOCK | RAW | (8) | ||
CHILD_PIN | RAW | (8) | ||
PERS_HEAP_MEM | NUMBER | |||
WORK_HEAP_MEM | NUMBER | |||
BIND_VARS | NUMBER | |||
DEFINE_VARS | NUMBER | |||
BIND_MEM_LOC | VARCHAR2 | (64) | ||
INST_FLAG | VARCHAR2 | (64) | ||
INST_FLAG2 | VARCHAR2 | (64) | ||
CHILD_HANDLE | RAW | (8) | ||
CON_ID | NUMBER |
Cut, paste (and edit) the following text to query this object:
SELECT INST_ID
, CURNO
, FLAG
, STATUS
, PARENT_HANDLE
, PARENT_LOCK
, CHILD_LOCK
, CHILD_PIN
, PERS_HEAP_MEM
, WORK_HEAP_MEM
, BIND_VARS
, DEFINE_VARS
, BIND_MEM_LOC
, INST_FLAG
, INST_FLAG2
, CHILD_HANDLE
, CON_ID
FROM SYS.GV_$SQL_CURSOR;
|
|
|