|
ALL_ |
DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| DAT...
| ENQ...
| INS...
| LOG...
| PGA...
| ROW...
| SES...
| SQL...
| SYS...
GV$LOGMNR_SESSION: Synonym for GV_$LOGMNR_SESSION
iSelfSchooling-SQL> desc GV$LOGMNR_SESSION;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SESSION_ID
NUMBER
SESSION_NAME
VARCHAR2(32)
SESSION_STATE
VARCHAR2(9)
DB_NAME
VARCHAR2(128)
DB_ID
NUMBER
RESET_SCN
NUMBER
RESET_TIMESTAMP
NUMBER
NUM_PROCESS
NUMBER
CHUNK_SIZE
NUMBER
START_SCN
NUMBER
END_SCN
NUMBER
SPILL_SCN
NUMBER
PROCESSED_SCN
NUMBER
PREPARED_SCN
NUMBER
READ_SCN
NUMBER
LOW_MARK_SCN
NUMBER
CONSUMED_SCN
NUMBER
MAX_MEMORY_SIZE
NUMBER
USED_MEMORY_SIZE
NUMBER
PREPARED_WORK_SIZE
NUMBER
AVAILABLE_WORK_SIZE
NUMBER
AVAILABLE_TXN
NUMBER
AVAILABLE_COMMITTED_TXN
NUMBER
DELIVERED_TXN
NUMBER
DELIVERED_COMMITTED_TXN
NUMBER
PINNED_TXN
NUMBER
PINNED_COMMITTED_TXN
NUMBER
CHECKPOINT_INTERVAL
NUMBER
GV$LOGMNR_STATS: Synonym for GV_$LOGMNR_STATS
iSelfSchooling-SQL> desc GV$LOGMNR_STATS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SESSION_ID
NUMBER
NAME
VARCHAR2(32)
VALUE
VARCHAR2(21)
GV$LOGMNR_TRANSACTION: Synonym for GV_$LOGMNR_TRANSACTION
iSelfSchooling-SQL> desc GV$LOGMNR_TRANSACTION;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SESSION_ID
NUMBER
XID
RAW(8)
XIDUSN
NUMBER
XIDSLT
NUMBER
XIDSQN
NUMBER
PARENT_XID
RAW(8)
PARENT_XIDUSN
NUMBER
PARENT_XIDSLT
NUMBER
PARENT_XIDSQN
NUMBER
START_TIME
DATE
START_SCN
NUMBER
CHUNK#
NUMBER
TOTAL_CHUNKS NUMBER
REDO_THREAD
NUMBER
LOW_TIME
DATE
LOW_SCN
NUMBER
HIGH_TIME
DATE
HIGH_SCN
NUMBER
LCR_COUNT
NUMBER
SPILLED_LCR_COUNT
NUMBER
DFLAG
NUMBER
MFLAG
NUMBER
MFLAG2
NUMBER
STATE
VARCHAR2(32)
TYPE
VARCHAR2(32)
MINING_STATUS
VARCHAR2(32)
QUEUE
VARCHAR2(32)
GV$LOGSTDBY: Synonym for GV_$LOGSTDBY
iSelfSchooling-SQL> desc GV$LOGSTDBY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SERIAL#
NUMBER
LOGSTDBY_ID
NUMBER
PID
VARCHAR2(12)
TYPE
VARCHAR2(30)
STATUS_CODE
NUMBER
STATUS
VARCHAR2(256)
HIGH_SCN
NUMBER
GV$LOGSTDBY_PROCESS: Synonym for GV_$LOGSTDBY_PROCESS
iSelfSchooling-SQL> desc GV$LOGSTDBY_PROCESS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
SID
NUMBER
SERIAL#
NUMBER
LOGSTDBY_ID
NUMBER
SPID
VARCHAR2(12)
TYPE
VARCHAR2(30)
STATUS_CODE
NUMBER
STATUS
VARCHAR2(256)
HIGH_SCN
NUMBER
GV$LOGSTDBY_PROGRESS: Synonym for GV_$LOGSTDBY_PROGRESS
iSelfSchooling-SQL> desc GV$LOGSTDBY_PROGRESS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
APPLIED_SCN
NUMBER
APPLIED_TIME
DATE
RESTART_SCN
NUMBER
RESTART_TIME
DATE
LATEST_SCN
NUMBER
LATEST_TIME
DATE
MINING_SCN
NUMBER
MINING_TIME
DATE
GV$LOGSTDBY_STATE: Synonym for GV_$LOGSTDBY_STATE
iSelfSchooling-SQL> desc GV$LOGSTDBY_STATE;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
PRIMARY_DBID
NUMBER
SESSION_ID
NUMBER
REALTIME_APPLY
VARCHAR2(64)
STATE
VARCHAR2(64)
GV$LOGSTDBY_STATS: Synonym for GV_$LOGSTDBY_STATS
iSelfSchooling-SQL> desc GV$LOGSTDBY_STATS;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
NAME
VARCHAR2(64)
VALUE
VARCHAR2(64)
GV$LOGSTDBY_TRANSACTION: Synonym for GV_$LOGSTDBY_TRANSACTION
iSelfSchooling-SQL> desc GV$LOGSTDBY_TRANSACTION;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
PRIMARY_XID
RAW(8)
PRIMARY_START_SCN
NUMBER
PRIMARY_START_TIME
DATE
PRIMARY_PARENT_XID
RAW(8)
MINING_STATUS
VARCHAR2(32)
APPLY_STATUS
VARCHAR2(6)
SID
NUMBER
SERIAL#
NUMBER
GV$LOG_HISTORY: Synonym for GV_$LOG_HISTORY
iSelfSchooling-SQL> desc GV$LOG_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
RECID
NUMBER
STAMP
NUMBER
THREAD#
NUMBER
SEQUENCE#
NUMBER
FIRST_CHANGE#
NUMBER
FIRST_TIME
DATE
NEXT_CHANGE#
NUMBER
RESETLOGS_CHANGE# NUMBER
RESETLOGS_TIME
DATE
GV$MANAGED_STANDBY: Synonym for GV_$MANAGED_STANDBY
iSelfSchooling-SQL> desc GV$MANAGED_STANDBY;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
PROCESS
VARCHAR2(9)
PID
NUMBER
STATUS
VARCHAR2(12)
CLIENT_PROCESS
VARCHAR2(8)
CLIENT_PID
VARCHAR2(40)
CLIENT_DBID
VARCHAR2(40)
GROUP#
VARCHAR2(40)
RESETLOG_ID
NUMBER
THREAD#
NUMBER
SEQUENCE#
NUMBER
BLOCK#
NUMBER
BLOCKS
NUMBER
DELAY_MINS
NUMBER
KNOWN_AGENTS
NUMBER
ACTIVE_AGENTS
NUMBER
GV$MAP_COMP_LIST: Synonym for GV_$MAP_COMP_LIST
iSelfSchooling-SQL> desc GV$MAP_COMP_LIST;
Name
Null? Type
----------------------------- -------- --------------------
INST_ID
NUMBER
ELEM_IDX
NUMBER
NUM_COMP
NUMBER
COMP1_NAME
VARCHAR2(256)
COMP1_VAL
VARCHAR2(256)
COMP2_NAME
VARCHAR2(256)
COMP2_VAL
VARCHAR2(256)
COMP3_NAME |