|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| DAT...
| ENQ...
| INS...
| LOG...
| PGA...
| ROW...
| SES...
| SQL...
| SYS...
GV$SQL_BIND_DATA: Synonym for GV_$SQL_BIND_DATA
iSelfSchooling-SQL> desc GV$SQL_BIND_DATA;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CURSOR_NUM
NUMBER
POSITION
NUMBER
DATATYPE
NUMBER
SHARED_MAX_LEN
NUMBER
PRIVATE_MAX_LEN
NUMBER
ARRAY_SIZE
NUMBER
PRECISION
NUMBER
SCALE
NUMBER
SHARED_FLAG
NUMBER
SHARED_FLAG2
NUMBER
BUF_ADDRESS
RAW(8)
BUF_LENGTH
NUMBER
VAL_LENGTH
NUMBER
BUF_FLAG
NUMBER
INDICATOR
NUMBER
VALUE
VARCHAR2(4000)
GV$SQL_BIND_METADATA: Synonym for GV_$SQL_BIND_METADATA
iSelfSchooling-SQL> desc GV$SQL_BIND_METADATA;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDRESS
RAW(8)
POSITION
NUMBER
DATATYPE
NUMBER
MAX_LENGTH
NUMBER
ARRAY_LEN
NUMBER
BIND_NAME
VARCHAR2(30)
GV$SQL_CURSOR: Synonym for GV_$SQL_CURSOR
iSelfSchooling-SQL> desc GV$SQL_CURSOR;
Name
Null?
Type
----------------------------- -------- --------------------
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)
GV$SQL_JOIN_FILTER: Synonym for GV_$SQL_JOIN_FILTER
iSelfSchooling-SQL> desc GV$SQL_JOIN_FILTER;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
QC_SESSION_ID
NUMBER
QC_INSTANCE_ID
NUMBER
SQL_PLAN_HASH_VALUE
NUMBER
LENGTH
NUMBER
BITS_SET
NUMBER
FILTERED
NUMBER
PROBED
NUMBER
ACTIVE
NUMBER
GV$SQL_OPTIMIZER_ENV: Synonym for GV_$SQL_OPTIMIZER_ENV
iSelfSchooling-SQL> desc GV$SQL_OPTIMIZER_ENV;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDRESS
RAW(8)
HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
CHILD_ADDRESS
RAW(8)
CHILD_NUMBER
NUMBER
ID
NUMBER
NAME
VARCHAR2(40)
ISDEFAULT
VARCHAR2(3)
VALUE
VARCHAR2(25)
GV$SQL_PLAN: Synonym for GV_$SQL_PLAN
iSelfSchooling-SQL> desc GV$SQL_PLAN;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDRESS
RAW(8)
HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
PLAN_HASH_VALUE
NUMBER
CHILD_ADDRESS
RAW(8)
CHILD_NUMBER
NUMBER
TIMESTAMP
DATE
OPERATION
VARCHAR2(30)
OPTIONS
VARCHAR2(30)
OBJECT_NODE
VARCHAR2(40)
OBJECT#
NUMBER
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
OBJECT_ALIAS
VARCHAR2(65)
OBJECT_TYPE
VARCHAR2(20)
OPTIMIZER
VARCHAR2(20)
ID
NUMBER
PARENT_ID
NUMBER
DEPTH
NUMBER
POSITION
NUMBER
SEARCH_COLUMNS
NUMBER
COST
NUMBER
CARDINALITY
NUMBER
BYTES
NUMBER
OTHER_TAG
VARCHAR2(35)
PARTITION_START
VARCHAR2(5)
PARTITION_STOP
VARCHAR2(5)
PARTITION_ID
NUMBER
OTHER
VARCHAR2(4000)
DISTRIBUTION
VARCHAR2(20)
CPU_COST
NUMBER
IO_COST
NUMBER
TEMP_SPACE
NUMBER
ACCESS_PREDICATES
VARCHAR2(4000)
FILTER_PREDICATES
VARCHAR2(4000)
PROJECTION
VARCHAR2(4000)
TIME
NUMBER
QBLOCK_NAME
VARCHAR2(30)
REMARKS
VARCHAR2(4000)
OTHER_XML
CLOB
GV$SQL_PLAN_STATISTICS: Synonym for GV_$SQL_PLAN_STATISTICS
iSelfSchooling-SQL> desc GV$SQL_PLAN_STATISTICS;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
ADDRESS
RAW(8)
HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
PLAN_HASH_VALUE
NUMBER
CHILD_ADDRESS
RAW(8)
CHILD_NUMBER
NUMBER
OPERATION_ID
NUMBER
EXECUTIONS
NUMBER
LAST_STARTS
NUMBER
STARTS
NUMBER
LAST_OUTPUT_ROWS
NUMBER
OUTPUT_ROWS
NUMBER
LAST_CR_BUFFER_GETS
NUMBER
CR_BUFFER_GETS
NUMBER
LAST_CU_BUFFER_GETS
NUMBER
CU_BUFFER_GETS
NUMBER
LAST_DISK_READS
NUMBER
DISK_READS
NUMBER
LAST_DISK_WRITES
NUMBER
DISK_WRITES
NUMBER
LAST_ELAPSED_TIME
NUMBER
ELAPSED_TIME
NUMBER
GV$SQL_PLAN_STATISTICS_ALL: Synonym for GV_$SQL_PLAN_STATISTICS_ALL
iSelfSchooling-SQL> desc GV$SQL_PLAN_STATISTICS_ALL;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDRESS
RAW(8)
HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
PLAN_HASH_VALUE
NUMBER
CHILD_ADDRESS
RAW(8)
CHILD_NUMBER
NUMBER
TIMESTAMP
DATE
OPERATION
VARCHAR2(30)
OPTIONS
VARCHAR2(30)
OBJECT_NODE
VARCHAR2(40)
OBJECT#
NUMBER
OBJECT_OWNER
VARCHAR2(30)
OBJECT_NAME
VARCHAR2(30)
OBJECT_ALIAS
VARCHAR2(65)
OBJECT_TYPE
VARCHAR2(20)
OPTIMIZER
VARCHAR2(20)
ID
NUMBER
PARENT_ID
NUMBER
DEPTH
NUMBER
POSITION
NUMBER
SEARCH_COLUMNS
NUMBER
COST
NUMBER
CARDINALITY
NUMBER
BYTES
NUMBER
OTHER_TAG
VARCHAR2(35)
PARTITION_START
VARCHAR2(5)
PARTITION_STOP
VARCHAR2(5)
PARTITION_ID
NUMBER
OTHER
VARCHAR2(4000)
DISTRIBUTION &nb |