|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| BUF...
| DEL...
| FLA...
| LOG...
| MTT...
| PX...
| SEG...
| SOR...
| SQL...
| TEM...
V$SORT_USAGE: Synonym for V_$SORT_USAGE
iSelfSchooling-SQL> desc V$SORT_USAGE;
Name
Null? Type
----------------------------- -------- --------------------
USERNAME
VARCHAR2(30)
USER
VARCHAR2(30)
SESSION_ADDR
RAW(8)
SESSION_NUM
NUMBER
SQLADDR
RAW(8)
SQLHASH
NUMBER
SQL_ID
VARCHAR2(13)
TABLESPACE
VARCHAR2(31)
CONTENTS
VARCHAR2(9)
SEGTYPE
VARCHAR2(9)
SEGFILE#
NUMBER
SEGBLK#
NUMBER
EXTENTS
NUMBER
BLOCKS
NUMBER
SEGRFNO#
NUMBER
V$SPPARAMETER: Synonym for V_$SPPARAMETER
iSelfSchooling-SQL> desc V$SPPARAMETER;
Name
Null? Type
----------------------------- -------- --------------------
SID
VARCHAR2(80)
NAME
VARCHAR2(80)
VALUE
VARCHAR2(255)
DISPLAY_VALUE
VARCHAR2(255)
ISSPECIFIED
VARCHAR2(6)
ORDINAL
NUMBER
UPDATE_COMMENT
VARCHAR2(255)
V$SQL: Synonym for V_$SQL
iSelfSchooling-SQL> desc V$SQL;
Name
Null? Type
----------------------------- -------- --------------------
SQL_TEXT
VARCHAR2(1000)
SQL_FULLTEXT
CLOB
SQL_ID
VARCHAR2(13)
SHARABLE_MEM
NUMBER
PERSISTENT_MEM
NUMBER
RUNTIME_MEM
NUMBER
SORTS
NUMBER
LOADED_VERSIONS
NUMBER
OPEN_VERSIONS
NUMBER
USERS_OPENING
NUMBER
FETCHES
NUMBER
EXECUTIONS
NUMBER
PX_SERVERS_EXECUTIONS
NUMBER
END_OF_FETCH_COUNT
NUMBER
USERS_EXECUTING
NUMBER
LOADS
NUMBER
FIRST_LOAD_TIME
VARCHAR2(19)
INVALIDATIONS
NUMBER
PARSE_CALLS
NUMBER
DISK_READS
NUMBER
DIRECT_WRITES
NUMBER
BUFFER_GETS
NUMBER
APPLICATION_WAIT_TIME
NUMBER
CONCURRENCY_WAIT_TIME
NUMBER
CLUSTER_WAIT_TIME
NUMBER
USER_IO_WAIT_TIME
NUMBER
PLSQL_EXEC_TIME
NUMBER
JAVA_EXEC_TIME
NUMBER
ROWS_PROCESSED
NUMBER
COMMAND_TYPE
NUMBER
OPTIMIZER_MODE
VARCHAR2(10)
OPTIMIZER_COST
NUMBER
OPTIMIZER_ENV
RAW(797)
OPTIMIZER_ENV_HASH_VALUE
NUMBER
PARSING_USER_ID
NUMBER
PARSING_SCHEMA_ID
NUMBER
PARSING_SCHEMA_NAME
VARCHAR2(30)
KEPT_VERSIONS
NUMBER
ADDRESS
RAW(8)
TYPE_CHK_HEAP
RAW(8)
HASH_VALUE
NUMBER
OLD_HASH_VALUE
NUMBER
PLAN_HASH_VALUE
NUMBER
CHILD_NUMBER
NUMBER
SERVICE
VARCHAR2(64)
SERVICE_HASH
NUMBER
MODULE
VARCHAR2(64)
MODULE_HASH
NUMBER
ACTION
VARCHAR2(64)
ACTION_HASH
NUMBER
SERIALIZABLE_ABORTS
NUMBER
OUTLINE_CATEGORY
VARCHAR2(64)
CPU_TIME
NUMBER
ELAPSED_TIME
NUMBER
OUTLINE_SID
NUMBER
CHILD_ADDRESS
RAW(8)
SQLTYPE
NUMBER
REMOTE
VARCHAR2(1)
OBJECT_STATUS
VARCHAR2(19)
LITERAL_HASH_VALUE
NUMBER
LAST_LOAD_TIME
VARCHAR2(19)
IS_OBSOLETE
VARCHAR2(1)
CHILD_LATCH
NUMBER
SQL_PROFILE
VARCHAR2(64)
PROGRAM_ID
NUMBER
PROGRAM_LINE#
NUMBER
EXACT_MATCHING_SIGNATURE
NUMBER
FORCE_MATCHING_SIGNATURE
NUMBER
LAST_ACTIVE_TIME
DATE
BIND_DATA
RAW(2000)
V$SQLAREA: Synonym for V_$SQLAREA
iSelfSchooling-SQL> desc V$SQLAREA;
Name
Null? Type
----------------------------- -------- --------------------
SQL_TEXT
VARCHAR2(1000)
SQL_FULLTEXT
CLOB
SQL_ID
VARCHAR2(13)
SHARABLE_MEM
NUMBER
PERSISTENT_MEM NUMBER
RUNTIME_MEM
NUMBER
SORTS
NUMBER
VERSION_COUNT
NUMBER
LOADED_VERSIONS
NUMBER
OPEN_VERSIONS
NUMBER
USERS_OPENING
NUMBER
FETCHES
NUMBER
EXECUTIONS
NUMBER
PX_SERVERS_EXECUTIONS
NUMBER
END_OF_FETCH_COUNT
NUMBER
USERS_EXECUTING
NUMBER
LOADS
NUMBER
FIRST_LOAD_TIME
VARCHAR2(19)
INVALIDATIONS
NUMBER
PARSE_CALLS
NUMBER
DISK_READS
NUMBER
DIRECT_WRITES
NUMBER
BUFFER_GETS
NUMBER
APPLICATION_WAIT_TIME
NUMBER
CONCURRENCY_WAIT_TIME
NUMBER
CLUSTER_WAIT_TIME
NUMBER
USER_IO_WAIT_TIME
NUMBER
PLSQL_EXEC_TIME
NUMBER
JAVA_EXEC_TIME
NUMBER
ROWS_PROCESSED
NUMBER
COMMAND_TYPE
NUMBER
OPTIMIZER_MODE
VARCHAR2(10)
OPTIMIZER_COST
NUMBER
OPTIMIZER_ENV
RAW(797)
OPTIMIZER_ENV_HASH_VALUE
NUMBER
PARSING_USER_ID
NUMBER
PARSING_SCHEMA_ID
NUMBER
PARSING_SCHEMA_NAME
VARCHAR2(30)
KEPT_VERSIONS
NUMBER
ADDRESS
RAW(8)
HASH_VALUE
NUMBER
OLD_HASH_VALUE
NUMBER
PLAN_HASH_VALUE
NUMBER
MODULE
VARCHAR2(64)
MODULE_HASH
NUMBER
ACTION
VARCHAR2(64)
ACTION_HASH
NUMBER
SERIALIZABLE_ABORTS
NUMBER
OUTLINE_CATEGORY
VARCHAR2(64)
CPU_TIME
NUMBER
ELAPSED_TIME
NUMBER
OUTLINE_SID
VARCHAR2(40)
LAST_ACTIVE_CHILD_ADDRESS
RAW(8)
REMOTE
VARCHAR2(1)
OBJECT_STATUS
VARCHAR2(19)
LITERAL_HASH_VALUE
NUMBER
LAST_LOAD_TIME
DATE
IS_OBSOLETE
VARCHAR2(1)
CHILD_LATCH
NUMBER
SQL_PROFILE
VARCHAR2(64)
PROGRAM_ID
NUMBER
PROGRAM_LINE#
NUMBER
EXACT_MATCHING_SIGNATURE
NUMBER
FORCE_MATCHING_SIGNATURE
NUMBER
LAST_ACTIVE_TIME
DATE
BIND_DATA
RAW(2000)
V$SQLAREA_PLAN_HASH: Synonym for V_$SQLAREA_PLAN_HASH
iSelfSchooling-SQL> desc V$SQLAREA_PLAN_HASH;
Name
Null?
Type
----------------------------- -------- --------------------
SQL_TEXT
VARCHAR2(1000)
|