ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| DAT...
| ENQ...
| INS...
| LOG...
| PGA...
| ROW...
| SES...
| SQL...
| SYS...
GV$SESSION_WAIT_HISTORY: Synonym for GV_$SESSION_WAIT_HISTORY
iSelfSchooling-SQL> desc GV$SESSION_WAIT_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
SEQ#
NUMBER
EVENT#
NUMBER
EVENT
VARCHAR2(64)
P1TEXT
VARCHAR2(64)
P1
NUMBER
P2TEXT
VARCHAR2(64)
P2
NUMBER
P3TEXT
VARCHAR2(64)
P3
NUMBER
WAIT_TIME
NUMBER
WAIT_COUNT
NUMBER
GV$SESSMETRIC: Synonym for GV_$SESSMETRIC
iSelfSchooling-SQL> desc GV$SESSMETRIC;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
BEGIN_TIME
DATE
END_TIME
DATE
INTSIZE_CSEC
NUMBER
SESSION_ID
NUMBER
SERIAL_NUM
NUMBER
CPU
NUMBER
PHYSICAL_READS
NUMBER
LOGICAL_READS
NUMBER
PGA_MEMORY
NUMBER
HARD_PARSES
NUMBER
SOFT_PARSES
NUMBER
PHYSICAL_READ_PCT
NUMBER
LOGICAL_READ_PCT
NUMBER
GV$SESSTAT: Synonym for GV_$SESSTAT
iSelfSchooling-SQL> desc GV$SESSTAT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
STATISTIC#
NUMBER
VALUE
NUMBER
GV$SESS_IO: Synonym for GV_$SESS_IO
iSelfSchooling-SQL> desc GV$SESS_IO;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
BLOCK_GETS
NUMBER
CONSISTENT_GETS
NUMBER
PHYSICAL_READS
NUMBER
BLOCK_CHANGES
NUMBER
CONSISTENT_CHANGES
NUMBER
GV$SESS_TIME_MODEL: Synonym for GV_$SESS_TIME_MODEL
iSelfSchooling-SQL> desc GV$SESS_TIME_MODEL;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
STAT_ID
NUMBER
STAT_NAME
VARCHAR2(64)
VALUE
NUMBER
GV$SES_OPTIMIZER_ENV: Synonym for GV_$SES_OPTIMIZER_ENV
iSelfSchooling-SQL> desc GV$SES_OPTIMIZER_ENV;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
ID
NUMBER
NAME
VARCHAR2(40)
ISDEFAULT
VARCHAR2(3)
VALUE
VARCHAR2(25)
GV$SGA: Synonym for GV_$SGA
iSelfSchooling-SQL> desc GV$SGA;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(20)
VALUE
NUMBER
GV$SGAINFO: Synonym for GV_$SGAINFO
iSelfSchooling-SQL> desc GV$SGAINFO;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(32)
BYTES
NUMBER
RESIZEABLE
VARCHAR2(3)
GV$SGASTAT: Synonym for GV_$SGASTAT
iSelfSchooling-SQL> desc GV$SGASTAT;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
POOL
VARCHAR2(12)
NAME
VARCHAR2(26)
BYTES
NUMBER
GV$SGA_CURRENT_RESIZE_OPS: Synonym for GV_$SGA_CURRENT_RESIZE_OPS
iSelfSchooling-SQL> desc GV$SGA_CURRENT_RESIZE_OPS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
COMPONENT
VARCHAR2(64)
OPER_TYPE
VARCHAR2(13)
OPER_MODE
VARCHAR2(9)
PARAMETER
VARCHAR2(80)
INITIAL_SIZE
NUMBER
TARGET_SIZE
NUMBER
CURRENT_SIZE
NUMBER
START_TIME
DATE
LAST_UPDATE_TIME
DATE
GV$SGA_DYNAMIC_COMPONENTS: Synonym for GV_$SGA_DYNAMIC_COMPONENTS
iSelfSchooling-SQL> desc GV$SGA_DYNAMIC_COMPONENTS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
COMPONENT
VARCHAR2(64)
CURRENT_SIZE
NUMBER
MIN_SIZE
NUMBER
MAX_SIZE
NUMBER
USER_SPECIFIED_SIZE
NUMBER
OPER_COUNT
NUMBER
LAST_OPER_TYPE
VARCHAR2(13)
LAST_OPER_MODE
VARCHAR2(9)
LAST_OPER_TIME
DATE
GRANULE_SIZE
NUMBER
GV$SGA_DYNAMIC_FREE_MEMORY: Synonym for GV_$SGA_DYNAMIC_FREE_MEMORY
iSelfSchooling-SQL> desc GV$SGA_DYNAMIC_FREE_MEMORY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
CURRENT_SIZE
NUMBER
GV$SGA_RESIZE_OPS: Synonym for GV_$SGA_RESIZE_OPS
iSelfSchooling-SQL> desc GV$SGA_RESIZE_OPS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
COMPONENT
VARCHAR2(64)
OPER_TYPE
VARCHAR2(13)
OPER_MODE
VARCHAR2(9)
PARAMETER
VARCHAR2(80)
INITIAL_SIZE
NUMBER
TARGET_SIZE
NUMBER
FINAL_SIZE
NUMBER
STATUS
VARCHAR2(9)
START_TIME
DATE
END_TIME
DATE
iSelfSchooling-SQL> desc GV$SGA_RESIZE_OPS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
COMPONENT
VARCHAR2(64)
OPER_TYPE
VARCHAR2(13)
OPER_MODE
VARCHAR2(9)
PARAMETER
VARCHAR2(80)
INITIAL_SIZE
NUMBER
TARGET_SIZE
NUMBER
FINAL_SIZE
NUMBER
STATUS
VARCHAR2(9)
START_TIME
DATE
END_TIME
DATE
GV$SGA_TARGET_ADVICE: Synonym for GV_$SGA_TARGET_ADVICE
iSelfSchooling-SQL> desc GV$SGA_TARGET_ADVICE;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SGA_SIZE
NUMBER
SGA_SIZE_FACTOR
NUMBER
ESTD_DB_TIME
NUMBER
ESTD_DB_TIME_FACTOR
NUMBER
ESTD_PHYSICAL_READS
NUMBER
GV$SHARED_POOL_ADVICE: Synonym for GV_$SHARED_POOL_ADVICE
iSelfSchooling-SQL> desc GV$SHARED_POOL_ADVICE;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SHARED_POOL_SIZE_FOR_ESTIMATE NUMBER
SHARED_POOL_SIZE_FACTOR
NUMBER
ESTD_LC_SIZE
NUMBER
ESTD_LC_MEMORY_OBJECTS
NUMBER
ESTD_LC_TIME_SAVED
NUMBER
ESTD_LC_TIME_SAVED_FACTOR
NUMBER
ESTD_LC_LOAD_TIME
NUMBER
ESTD_LC_LOAD_TIME_FACTOR
NUMBER
ESTD_LC_MEMORY_OBJECT_HITS
NUMBER
GV$SHARED_POOL_RESERVED: Synonym for GV_$SHARED_POOL_RESERVED
iSelfSchooling-SQL> desc GV$SHARED_POOL_RESERVED;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
FREE_SPACE
NUMBER
AVG_FREE_SIZE
NUMBER
FREE_COUNT
NUMBER
MAX_FREE_SIZE
NUMBER
USED_SPACE
NUMBER
AVG_USED_SIZE
NUMBER
USED_COUNT
NUMBER
MAX_USED_SIZE
NUMBER
REQUESTS
NUMBER
REQUEST_MISSES
NUMBER
LAST_MISS_SIZE
NUMBER
MAX_MISS_SIZE
NUMBER
REQUEST_FAILURES
NUMBER
LAST_FAILURE_SIZE
NUMBER
ABORTED_REQUEST_THRESHOLD
NUMBER
ABORTED_REQUESTS
NUMBER
LAST_ABORTED_SIZE
NUMBER
GV$SHARED_SERVER: Synonym for GV_$SHARED_SERVER
iSelfSchooling-SQL> desc GV$SHARED_SERVER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(4)
PADDR
RAW(8)
STATUS
VARCHAR2(16)
MESSAGES
NUMBER
BYTES
NUMBER
BREAKS
NUMBER
CIRCUIT
RAW(8)
IDLE
NUMBER
BUSY
NUMBER
REQUESTS
NUMBER
GV$SHARED_SERVER_MONITOR: Synonym for GV_$SHARED_SERVER_MONITOR
iSelfSchooling-SQL> desc GV$SHARED_SERVER_MONITOR;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
MAXIMUM_CONNECTIONS
NUMBER
MAXIMUM_SESSIONS
NUMBER
SERVERS_STARTED
NUMBER
SERVERS_TERMINATED
NUMBER
SERVERS_HIGHWATER
NUMBER
GV$SORT_SEGMENT: Synonym for GV_$SORT_SEGMENT
iSelfSchooling-SQL> desc GV$SORT_SEGMENT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
TABLESPACE_NAME
VARCHAR2(31)
SEGMENT_FILE
NUMBER
SEGMENT_BLOCK
NUMBER
EXTENT_SIZE
NUMBER
CURRENT_USERS
NUMBER
TOTAL_EXTENTS
NUMBER
TOTAL_BLOCKS
NUMBER
USED_EXTENTS
NUMBER
USED_BLOCKS
NUMBER
FREE_EXTENTS
NUMBER
FREE_BLOCKS
NUMBER
ADDED_EXTENTS
NUMBER
EXTENT_HITS
NUMBER
FREED_EXTENTS
NUMBER
FREE_REQUESTS
NUMBER
MAX_SIZE
NUMBER
MAX_BLOCKS
NUMBER
MAX_USED_SIZE
NUMBER
MAX_USED_BLOCKS
NUMBER
MAX_SORT_SIZE
NUMBER
MAX_SORT_BLOCKS
NUMBER
RELATIVE_FNO
NUMBER
GV$SORT_USAGE: Synonym for GV_$SORT_USAGE
iSelfSchooling-SQL> desc GV$SORT_USAGE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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
GV$SPPARAMETER: Synonym for GV_$SPPARAMETER
iSelfSchooling-SQL> desc GV$SPPARAMETER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
VARCHAR2(80)
NAME
VARCHAR2(80)
VALUE
VARCHAR2(255)
DISPLAY_VALUE
VARCHAR2(255)
ISSPECIFIED
VARCHAR2(6)
ORDINAL
NUMBER
UPDATE_COMMENT
VARCHAR2(255)
GV$SQL: Synonym for GV_$SQL
iSelfSchooling-SQL> desc GV$SQL;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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)
GV$SQLAREA: Synonym for GV_$SQLAREA
iSelfSchooling-SQL> desc GV$SQLAREA;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
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)
GV$SQLAREA_PLAN_HASH: Synonym for GV_$SQLAREA_PLAN_HASH
iSelfSchooling-SQL> desc GV$SQLAREA_PLAN_HASH;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SQL_TEXT
VARCHAR2(1000)
SQL_FULLTEXT
CLOB
ADDRESS
RAW(8)
HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
PLAN_HASH_VALUE
NUMBER
VERSION_COUNT
NUMBER
LAST_ACTIVE_CHILD_ADDRESS
RAW(8)
SHARABLE_MEM
NUMBER
PERSISTENT_MEM
NUMBER
RUNTIME_MEM
NUMBER
SORTS
NUMBER
LOADED_VERSIONS
NUMBER
OPEN_VERSIONS
NUMBER
USERS_OPENING
NUMBER
USERS_EXECUTING
NUMBER
FETCHES
NUMBER
EXECUTIONS
NUMBER
PX_SERVERS_EXECUTIONS
NUMBER
END_OF_FETCH_COUNT
NUMBER
LOADS
NUMBER
FIRST_LOAD_TIME
DATE
LAST_LOAD_TIME
DATE
LAST_ACTIVE_TIME
DATE
INVALIDATIONS
NUMBER
PARSE_CALLS
NUMBER
DISK_READS
NUMBER
DIRECT_WRITES
NUMBER
BUFFER_GETS
NUMBER
CPU_TIME
NUMBER
ELAPSED_TIME
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
MODULE
VARCHAR2(64)
MODULE_HASH
NUMBER
ACTION
VARCHAR2(64)
ACTION_HASH
NUMBER
SERIALIZABLE_ABORTS
NUMBER
OUTLINE_CATEGORY
VARCHAR2(64)
OUTLINE_SID
VARCHAR2(40)
REMOTE
VARCHAR2(1)
OBJECT_STATUS
VARCHAR2(19)
LITERAL_HASH_VALUE
NUMBER
SQL_PROFILE
VARCHAR2(64)
PROGRAM_ID
NUMBER
PROGRAM_LINE#
NUMBER
EXACT_MATCHING_SIGNATURE
NUMBER
FORCE_MATCHING_SIGNATURE
NUMBER
BIND_DATA
RAW(2000)
GV$SQLSTATS: Synonym for GV_$SQL
iSelfSchooling-SQL> desc GV$SQLSTATS;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
SQL_TEXT
VARCHAR2(1000)
SQL_FULLTEXT
CLOB
SQL_ID
VARCHAR2(13)
LAST_ACTIVE_TIME
DATE
LAST_ACTIVE_CHILD_ADDRESS
RAW(8)
PLAN_HASH_VALUE
NUMBER
PARSE_CALLS
NUMBER
DISK_READS
NUMBER
DIRECT_WRITES
NUMBER
BUFFER_GETS
NUMBER
ROWS_PROCESSED
NUMBER
SERIALIZABLE_ABORTS
NUMBER
FETCHES
NUMBER
EXECUTIONS
NUMBER
END_OF_FETCH_COUNT
NUMBER
LOADS
NUMBER
VERSION_COUNT
NUMBER
INVALIDATIONS
NUMBER
PX_SERVERS_EXECUTIONS
NUMBER
CPU_TIME
NUMBER
ELAPSED_TIME
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
SORTS
NUMBER
SHARABLE_MEM
NUMBER
TOTAL_SHARABLE_MEM
NUMBER
GV$SQLTEXT: Synonym for GV_$SQLTEXT
iSelfSchooling-SQL> desc GV$SQLTEXT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDRESS
RAW(8)
HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
COMMAND_TYPE
NUMBER
PIECE
NUMBER
SQL_TEXT
VARCHAR2(64)
GV$SQLTEXT_WITH_NEWLINES: Synonym for GV_$SQLTEXT_WITH_NEWLINES
iSelfSchooling-SQL> desc GV$SQLTEXT_WITH_NEWLINES;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDRESS
RAW(8)
HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
COMMAND_TYPE
NUMBER
PIECE
NUMBER
SQL_TEXT
VARCHAR2(64)
GV$SQL_BIND_CAPTURE: Synonym for GV_$SQL_BIND_CAPTURE
iSelfSchooling-SQL> desc GV$SQL_BIND_CAPTURE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID NUMBER
ADDRESS
RAW(8)
HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
CHILD_ADDRESS
RAW(8)
CHILD_NUMBER
NUMBER
NAME
VARCHAR2(30)
POSITION
NUMBER
DUP_POSITION
NUMBER
DATATYPE
NUMBER
DATATYPE_STRING
VARCHAR2(15)
CHARACTER_SID
NUMBER
PRECISION
NUMBER
SCALE
NUMBER
MAX_LENGTH
NUMBER
WAS_CAPTURED
VARCHAR2(3)
LAST_CAPTURED
DATE
VALUE_STRING
VARCHAR2(4000)
VALUE_ANYDATA
ANYDATA
|