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
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
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
POLICY
VARCHAR2(10)
ESTIMATED_OPTIMAL_SIZE
NUMBER
ESTIMATED_ONEPASS_SIZE
NUMBER
LAST_MEMORY_USED
NUMBER
LAST_EXECUTION
VARCHAR2(10)
LAST_DEGREE
NUMBER
TOTAL_EXECUTIONS
NUMBER
OPTIMAL_EXECUTIONS
NUMBER
ONEPASS_EXECUTIONS
NUMBER
MULTIPASSES_EXECUTIONS
NUMBER
ACTIVE_TIME
NUMBER
MAX_TEMPSEG_SIZE
NUMBER
LAST_TEMPSEG_SIZE
NUMBER
GV$SQL_REDIRECTION: Synonym for GV_$SQL_REDIRECTION
iSelfSchooling-SQL> desc GV$SQL_REDIRECTION;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDRESS
RAW(8)
PARENT_HANDLE
RAW(8)
HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
CHILD_NUMBER
NUMBER
PARSING_USER_ID
NUMBER
PARSING_SCHEMA_ID
NUMBER
COMMAND_TYPE
NUMBER
REASON
VARCHAR2(14)
ERROR_CODE
NUMBER
POSITION
NUMBER
SQL_TEXT_PIECE
VARCHAR2(1000)
ERROR_MESSAGE
VARCHAR2(1000)
GV$SQL_SHARED_CURSOR: Synonym for GV_$SQL_SHARED_CURSOR
iSelfSchooling-SQL> desc GV$SQL_SHARED_CURSOR;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SQL_ID
VARCHAR2(13)
ADDRESS
RAW(8)
CHILD_ADDRESS
RAW(8)
CHILD_NUMBER
NUMBER
UNBOUND_CURSOR
VARCHAR2(1)
SQL_TYPE_MISMATCH VARCHAR2(1)
OPTIMIZER_MISMATCH
VARCHAR2(1)
OUTLINE_MISMATCH
VARCHAR2(1)
STATS_ROW_MISMATCH
VARCHAR2(1)
LITERAL_MISMATCH
VARCHAR2(1)
SEC_DEPTH_MISMATCH
VARCHAR2(1)
EXPLAIN_PLAN_CURSOR
VARCHAR2(1)
BUFFERED_DML_MISMATCH
VARCHAR2(1)
PDML_ENV_MISMATCH
VARCHAR2(1)
INST_DRTLD_MISMATCH
VARCHAR2(1)
SLAVE_QC_MISMATCH
VARCHAR2(1)
TYPECHECK_MISMATCH
VARCHAR2(1)
AUTH_CHECK_MISMATCH
VARCHAR2(1)
BIND_MISMATCH
VARCHAR2(1)
DESCRIBE_MISMATCH
VARCHAR2(1)
LANGUAGE_MISMATCH
VARCHAR2(1)
TRANSLATION_MISMATCH
VARCHAR2(1)
ROW_LEVEL_SEC_MISMATCH
VARCHAR2(1)
INSUFF_PRIVS
VARCHAR2(1)
INSUFF_PRIVS_REM
VARCHAR2(1)
REMOTE_TRANS_MISMATCH
VARCHAR2(1)
LOGMINER_SESSION_MISMATCH
VARCHAR2(1)
INCOMP_LTRL_MISMATCH
VARCHAR2(1)
OVERLAP_TIME_MISMATCH
VARCHAR2(1)
SQL_REDIRECT_MISMATCH
VARCHAR2(1)
MV_QUERY_GEN_MISMATCH
VARCHAR2(1)
USER_BIND_PEEK_MISMATCH
VARCHAR2(1)
TYPCHK_DEP_MISMATCH
VARCHAR2(1)
NO_TRIGGER_MISMATCH
VARCHAR2(1)
FLASHBACK_CURSOR
VARCHAR2(1)
ANYDATA_TRANSFORMATION
VARCHAR2(1)
INCOMPLETE_CURSOR
VARCHAR2(1)
TOP_LEVEL_RPI_CURSOR
VARCHAR2(1)
DIFFERENT_LONG_LENGTH
VARCHAR2(1)
LOGICAL_STANDBY_APPLY
VARCHAR2(1)
DIFF_CALL_DURN
VARCHAR2(1)
BIND_UACS_DIFF
VARCHAR2(1)
PLSQL_CMP_SWITCHS_DIFF
VARCHAR2(1)
CURSOR_PARTS_MISMATCH
VARCHAR2(1)
STB_OBJECT_MISMATCH
VARCHAR2(1)
ROW_SHIP_MISMATCH
VARCHAR2(1)
PQ_SLAVE_MISMATCH
VARCHAR2(1)
TOP_LEVEL_DDL_MISMATCH
VARCHAR2(1)
MULTI_PX_MISMATCH
VARCHAR2(1)
BIND_PEEKED_PQ_MISMATCH
VARCHAR2(1)
MV_REWRITE_MISMATCH
VARCHAR2(1)
ROLL_INVALID_MISMATCH
VARCHAR2(1)
OPTIMIZER_MODE_MISMATCH
VARCHAR2(1)
PX_MISMATCH
VARCHAR2(1)
MV_STALEOBJ_MISMATCH
VARCHAR2(1)
FLASHBACK_TABLE_MISMATCH
VARCHAR2(1)
LITREP_COMP_MISMATCH
VARCHAR2(1)
GV$SQL_SHARED_MEMORY: Synonym for GV_$SQL_SHARED_MEMORY
iSelfSchooling-SQL> desc GV$SQL_SHARED_MEMORY;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SQL_TEXT
VARCHAR2(1000)
SQL_FULLTEXT
CLOB
HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
HEAP_DESC
RAW(8)
STRUCTURE
VARCHAR2(16)
FUNCTION
VARCHAR2(16)
CHUNK_COM
VARCHAR2(16)
CHUNK_PTR
RAW(8)
CHUNK_SIZE
NUMBER
ALLOC_CLASS
VARCHAR2(8)
CHUNK_TYPE
NUMBER
SUBHEAP_DESC
RAW(8)
GV$SQL_WORKAREA: Synonym for GV_$SQL_WORKAREA
iSelfSchooling-SQL> desc GV$SQL_WORKAREA;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ADDRESS
RAW(8)
HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
CHILD_NUMBER
NUMBER
WORKAREA_ADDRESS
RAW(8)
OPERATION_TYPE
VARCHAR2(20)
OPERATION_ID
NUMBER
POLICY
VARCHAR2(10)
ESTIMATED_OPTIMAL_SIZE
NUMBER
ESTIMATED_ONEPASS_SIZE
NUMBER
LAST_MEMORY_USED
NUMBER
LAST_EXECUTION
VARCHAR2(10)
LAST_DEGREE
NUMBER
TOTAL_EXECUTIONS
NUMBER
OPTIMAL_EXECUTIONS
NUMBER
ONEPASS_EXECUTIONS
NUMBER
MULTIPASSES_EXECUTIONS
NUMBER
ACTIVE_TIME
NUMBER
MAX_TEMPSEG_SIZE
NUMBER
LAST_TEMPSEG_SIZE
NUMBER
GV$SQL_WORKAREA_ACTIVE: Synonym for GV_$SQL_WORKAREA_ACTIVE
iSelfSchooling-SQL> desc GV$SQL_WORKAREA_ACTIVE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SQL_HASH_VALUE
NUMBER
SQL_ID
VARCHAR2(13)
WORKAREA_ADDRESS
RAW(8)
OPERATION_TYPE
VARCHAR2(20)
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
GV$SQL_WORKAREA_HISTOGRAM: Synonym for GV_$SQL_WORKAREA_HISTOGRAM
iSelfSchooling-SQL> desc GV$SQL_WORKAREA_HISTOGRAM;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
LOW_OPTIMAL_SIZE
NUMBER
HIGH_OPTIMAL_SIZE
NUMBER
OPTIMAL_EXECUTIONS
NUMBER
ONEPASS_EXECUTIONS
NUMBER
MULTIPASSES_EXECUTIONS
NUMBER
TOTAL_EXECUTIONS
NUMBER
GV$STANDBY_APPLY_SNAPSHOT: Synonym for GV_$STANDBY_APPLY_SNAPSHOT
iSelfSchooling-SQL> desc GV$STANDBY_APPLY_SNAPSHOT;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SNAPSHOT_TIME
DATE
SESSION_ID
NUMBER
THREAD#
NUMBER
RESET_TIMESTAMP
NUMBER
SEQUENCE#
NUMBER
BLOCK#
NUMBER
APPLIED_SCN
NUMBER
APPLIED_TIME
DATE
NEWEST_RESET_TIMESTAMP
NUMBER
NEWEST_ARCHIVED_SEQ#
NUMBER
NEWEST_TIME
DATE
NEWEST_USED
NUMBER
NEWEST_SRL_SEQ#
NUMBER
BLOCKSIZE
NUMBER
APPLY_RATE
NUMBER
GV$STANDBY_LOG: Synonym for GV_$STANDBY_LOG
iSelfSchooling-SQL> desc GV$STANDBY_LOG;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
GROUP#
NUMBER
DBID
VARCHAR2(40)
THREAD#
NUMBER
SEQUENCE#
NUMBER
BYTES
NUMBER
USED
NUMBER
ARCHIVED
VARCHAR2(3)
STATUS
VARCHAR2(10)
FIRST_CHANGE#
NUMBER
FIRST_TIME
DATE
LAST_CHANGE#
NUMBER
LAST_TIME
DATE
GV$STATISTICS_LEVEL: Synonym for GV_$STATISTICS_LEVEL
iSelfSchooling-SQL> desc GV$STATISTICS_LEVEL;
Name
Null?
Type
----------------------------- -------- --------------------
INST_ID
NUMBER
STATISTICS_NAME
VARCHAR2(64)
DESCRIPTION
VARCHAR2(4000)
SESSION_STATUS
VARCHAR2(8)
SYSTEM_STATUS
VARCHAR2(8)
ACTIVATION_LEVEL
VARCHAR2(7)
STATISTICS_VIEW_NAME
VARCHAR2(64)
SESSION_SETTABLE
VARCHAR2(3)
GV$STATNAME: Synonym for GV_$STATNAME
iSelfSchooling-SQL> desc GV$STATNAME;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
STATISTIC#
NUMBER
NAME
VARCHAR2(64)
CLASS
NUMBER
STAT_ID
NUMBER
GV$STREAMS_APPLY_COORDINATOR:
Synonym
for GV_$STREAMS_APPLY_COORDINATOR
iSelfSchooling-SQL> desc GV$STREAMS_APPLY_COORDINATOR;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
SERIAL#
NUMBER
APPLY#
NUMBER
APPLY_NAME
VARCHAR2(30)
STATE
VARCHAR2(21)
TOTAL_APPLIED
NUMBER
TOTAL_WAIT_DEPS
NUMBER
TOTAL_WAIT_COMMITS
NUMBER
TOTAL_ADMIN
NUMBER
TOTAL_ASSIGNED
NUMBER
TOTAL_RECEIVED
NUMBER
TOTAL_IGNORED
NUMBER
TOTAL_ROLLBACKS
NUMBER
TOTAL_ERRORS
NUMBER
LWM_TIME
DATE
LWM_MESSAGE_NUMBER
NUMBER
LWM_MESSAGE_CREATE_TIME
DATE
HWM_TIME
DATE
HWM_MESSAGE_NUMBER
NUMBER
HWM_MESSAGE_CREATE_TIME
DATE
STARTUP_TIME
DATE
ELAPSED_SCHEDULE_TIME
NUMBER
ELAPSED_IDLE_TIME
NUMBER
GV$STREAMS_APPLY_READER: Synonym for GV_$STREAMS_APPLY_READER
iSelfSchooling-SQL> desc GV$STREAMS_APPLY_READER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
SERIAL#
NUMBER
APPLY#
NUMBER
APPLY_NAME
VARCHAR2(30)
STATE
VARCHAR2(17)
TOTAL_MESSAGES_DEQUEUED
NUMBER
TOTAL_MESSAGES_SPILLED
NUMBER
DEQUEUE_TIME
DATE
DEQUEUED_MESSAGE_NUMBER
NUMBER
DEQUEUED_MESSAGE_CREATE_TIME DATE
SGA_USED
NUMBER
ELAPSED_DEQUEUE_TIME
NUMBER
ELAPSED_SCHEDULE_TIME
NUMBER
ELAPSED_SPILL_TIME
NUMBER
LAST_BROWSE_NUM
NUMBER
OLDEST_SCN_NUM
NUMBER
LAST_BROWSE_SEQ
NUMBER
LAST_DEQ_SEQ
NUMBER
OLDEST_XIDUSN
NUMBER
OLDEST_XIDSLT
NUMBER
OLDEST_XIDSQN
NUMBER
GV$STREAMS_APPLY_SERVER: Synonym for GV_$STREAMS_APPLY_SERVER
iSelfSchooling-SQL> desc GV$STREAMS_APPLY_SERVER;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
SERIAL#
NUMBER
APPLY#
NUMBER
APPLY_NAME
VARCHAR2(30)
SERVER_ID
NUMBER
STATE
VARCHAR2(20)
XIDUSN
NUMBER
XIDSLT
NUMBER
XIDSQN
NUMBER
COMMITSCN
NUMBER
DEP_XIDUSN
NUMBER
DEP_XIDSLT
NUMBER
DEP_XIDSQN
NUMBER
DEP_COMMITSCN
NUMBER
MESSAGE_SEQUENCE
NUMBER
TOTAL_ASSIGNED
NUMBER
TOTAL_ADMIN
NUMBER
TOTAL_ROLLBACKS
NUMBER
TOTAL_MESSAGES_APPLIED
NUMBER
APPLY_TIME
DATE
APPLIED_MESSAGE_NUMBER
NUMBER
APPLIED_MESSAGE_CREATE_TIME DATE
ELAPSED_DEQUEUE_TIME
NUMBER
ELAPSED_APPLY_TIME
NUMBER
GV$STREAMS_CAPTURE: Synonym for GV_$STREAMS_CAPTURE
iSelfSchooling-SQL> desc GV$STREAMS_CAPTURE;
Name
Null? Type
-----------------------------
-------- --------------------
INST_ID
NUMBER
SID
NUMBER
SERIAL#
NUMBER
CAPTURE#
NUMBER
CAPTURE_NAME
VARCHAR2(30)
LOGMINER_ID
NUMBER
STARTUP_TIME
DATE
STATE
VARCHAR2(73)
TOTAL_PREFILTER_DISCARDED
NUMBER
TOTAL_PREFILTER_KEPT
NUMBER
TOTAL_PREFILTER_EVALUATIONS NUMBER
TOTAL_MESSAGES_CAPTURED
NUMBER
CAPTURE_TIME
DATE
CAPTURE_MESSAGE_NUMBER
NUMBER
CAPTURE_MESSAGE_CREATE_TIME DATE
TOTAL_MESSAGES_CREATED
NUMBER
TOTAL_FULL_EVALUATIONS
NUMBER
TOTAL_MESSAGES_ENQUEUED
NUMBER
ENQUEUE_TIME
DATE
ENQUEUE_MESSAGE_NUMBER
NUMBER
ENQUEUE_MESSAGE_CREATE_TIME DATE
AVAILABLE_MESSAGE_NUMBER
NUMBER
AVAILABLE_MESSAGE_CREATE_TIME DATE
ELAPSED_CAPTURE_TIME
NUMBER
ELAPSED_RULE_TIME
NUMBER
ELAPSED_ENQUEUE_TIME
NUMBER
ELAPSED_LCR_TIME
NUMBER
ELAPSED_REDO_WAIT_TIME
NUMBER
ELAPSED_PAUSE_TIME
NUMBER
STATE_CHANGED_TIME
DATE
GV$STREAMS_POOL_ADVICE: Synonym for GV_$STREAMS_POOL_ADVICE
iSelfSchooling-SQL> desc GV$STREAMS_POOL_ADVICE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
STREAMS_POOL_SIZE_FOR_ESTIMAT NUMBER
STREAMS_POOL_SIZE_FACTOR NUMBER
ESTD_SPILL_COUNT
NUMBER
ESTD_SPILL_TIME
NUMBER
ESTD_UNSPILL_COUNT
NUMBER
ESTD_UNSPILL_TIME
NUMBER
GV$STREAMS_TRANSACTION: Synonym for GV_$STREAMS_TRANSACTION
iSelfSchooling-SQL> desc GV$STREAMS_TRANSACTION;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
STREAMS_NAME
VARCHAR2(30)
STREAMS_TYPE
VARCHAR2(10)
XIDUSN
NUMBER
XIDSLT
NUMBER
XIDSQN
NUMBER
CUMULATIVE_MESSAGE_COUNT
NUMBER
TOTAL_MESSAGE_COUNT
NUMBER
FIRST_MESSAGE_TIME
DATE
FIRST_MESSAGE_NUMBER
NUMBER
LAST_MESSAGE_TIME
DATE
LAST_MESSAGE_NUMBER
NUMBER
GV$SUBCACHE: Synonym for GV_$SUBCACHE
iSelfSchooling-SQL> desc GV$SUBCACHE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
OWNER_NAME
VARCHAR2(64)
NAME
VARCHAR2(1000)
TYPE
NUMBER
HEAP_NUM
NUMBER
CACHE_ID
NUMBER
CACHE_CNT
NUMBER
HEAP_SZ
NUMBER
HEAP_ALOC
NUMBER
HEAP_USED
NUMBER
GV$SYSAUX_OCCUPANTS: Synonym for GV_$SYSAUX_OCCUPANTS
iSelfSchooling-SQL> desc GV$SYSAUX_OCCUPANTS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
OCCUPANT_NAME
VARCHAR2(64)
OCCUPANT_DESC
VARCHAR2(64)
SCHEMA_NAME
VARCHAR2(64)
MOVE_PROCEDURE
VARCHAR2(64)
MOVE_PROCEDURE_DESC
VARCHAR2(64)
SPACE_USAGE_KBYTES
NUMBER
GV$SYSMETRIC: Synonym for GV_$SYSMETRIC
iSelfSchooling-SQL> desc GV$SYSMETRIC;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
BEGIN_TIME
DATE
END_TIME
DATE
INTSIZE_CSEC NUMBER
GROUP_ID
NUMBER
METRIC_ID
NUMBER
METRIC_NAME
VARCHAR2(64)
VALUE
NUMBER
METRIC_UNIT
VARCHAR2(64)
|