|
ALL_ | DBA_ |
USER_ |
GV$
| V$ |
Others
ACC...
| BAC...
| BUF...
| DEL...
| FLA...
| LOG...
| MTT...
| PX...
| SEG...
| SOR...
| SQL...
| TEM...
V$LOG: Synonym for V_$LOG
iSelfSchooling-SQL> desc V$LOG;
Name
Null? Type
----------------------------- -------- --------------------
GROUP#
NUMBER
THREAD#
NUMBER
SEQUENCE#
NUMBER
BYTES
NUMBER
MEMBERS
NUMBER
ARCHIVED
VARCHAR2(3)
STATUS
VARCHAR2(16)
FIRST_CHANGE#
NUMBER
FIRST_TIME
DATE
V$LOGFILE: Synonym for V_$LOGFILE
iSelfSchooling-SQL> desc V$LOGFILE;
Name
Null?
Type
----------------------------- -------- --------------------
GROUP#
NUMBER
STATUS
VARCHAR2(7)
TYPE
VARCHAR2(7)
MEMBER
VARCHAR2(513)
IS_RECOVERY_DEST_FILE
VARCHAR2(3)
V$LOGHIST: Synonym for V_$LOGHIST
iSelfSchooling-SQL> desc V$LOGHIST;
Name
Null? Type
----------------------------- -------- --------------------
THREAD#
NUMBER
SEQUENCE#
NUMBER
FIRST_CHANGE#
NUMBER
FIRST_TIME
DATE
SWITCH_CHANGE#
NUMBER
V$LOGMNR_CALLBACK: Synonym for V_$LOGMNR_CALLBACK
iSelfSchooling-SQL> desc V$LOGMNR_CALLBACK;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_ID
NUMBER
FUNCTION_ID
NUMBER
DESCRIPTION
VARCHAR2(64)
TYPE
VARCHAR2(15)
V$LOGMNR_CONTENTS: Synonym for V_$LOGMNR_CONTENTS
iSelfSchooling-SQL> desc V$LOGMNR_CONTENTS;
Name
Null? Type
----------------------------- -------- --------------------
SCN
NUMBER
CSCN
NUMBER
TIMESTAMP
DATE
COMMIT_TIMESTAMP
DATE
THREAD#
NUMBER
LOG_ID
NUMBER
XIDUSN
NUMBER
XIDSLT
NUMBER
XIDSQN
NUMBER
PXIDUSN
NUMBER
PXIDSLT
NUMBER
PXIDSQN
NUMBER
RBASQN
NUMBER
RBABLK
NUMBER
RBABYTE
NUMBER
UBAFIL
NUMBER
UBABLK
NUMBER
UBAREC
NUMBER
UBASQN
NUMBER
ABS_FILE#
NUMBER
REL_FILE#
NUMBER
DATA_BLK#
NUMBER
DATA_OBJ#
NUMBER
DATA_OBJD#
NUMBER
SEG_OWNER
VARCHAR2(32)
SEG_NAME
VARCHAR2(256)
TABLE_NAME
VARCHAR2(32)
SEG_TYPE
NUMBER
SEG_TYPE_NAME
VARCHAR2(32)
TABLE_SPACE
VARCHAR2(32)
ROW_ID
VARCHAR2(18)
SESSION#
NUMBER
SERIAL#
NUMBER
USERNAME
VARCHAR2(30)
SESSION_INFO
VARCHAR2(4000)
TX_NAME
VARCHAR2(256)
ROLLBACK
NUMBER
OPERATION
VARCHAR2(32)
OPERATION_CODE
NUMBER
SQL_REDO
VARCHAR2(4000)
SQL_UNDO
VARCHAR2(4000)
RS_ID
VARCHAR2(32)
SEQUENCE#
NUMBER
SSN
NUMBER
CSF
NUMBER
INFO
VARCHAR2(32)
STATUS
NUMBER
REDO_VALUE
NUMBER
UNDO_VALUE
NUMBER
SQL_COLUMN_TYPE
VARCHAR2(30)
SQL_COLUMN_NAME
VARCHAR2(30)
REDO_LENGTH
NUMBER
REDO_OFFSET
NUMBER
UNDO_LENGTH
NUMBER
UNDO_OFFSET
NUMBER
DATA_OBJV#
NUMBER
SAFE_RESUME_SCN
NUMBER
XID
RAW(8)
PXID
RAW(8)
AUDIT_SESSIONID
NUMBER
V$LOGMNR_DICTIONARY: Synonym for V_$LOGMNR_DICTIONARY
iSelfSchooling-SQL> desc V$LOGMNR_DICTIONARY;
Name
Null? Type
----------------------------- -------- --------------------
DB_NAME
VARCHAR2(9)
DB_ID
NUMBER
DB_CREATED
DATE
TIMESTAMP
DATE
RESET_SCN
NUMBER
RESET_SCN_TIME
DATE
DB_VERSION_TIME
DATE
DB_CHARACTER_SET
VARCHAR2(30)
DB_VERSION
VARCHAR2(64)
DB_STATUS
VARCHAR2(64)
DICTIONARY_SCN
NUMBER
ENABLED_THREAD_MAP
RAW(16)
DB_TXN_SCN
NUMBER
FILENAME
VARCHAR2(512)
INFO
VARCHAR2(32)
STATUS
NUMBER
V$LOGMNR_DICTIONARY_LOAD: Synonym for V_$LOGMNR_DICTIONARY_LOAD
iSelfSchooling-SQL> desc V$LOGMNR_DICTIONARY_LOAD;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_ID
NUMBER
LOGMNR_UID
NUMBER
ACTION#
NUMBER
OPCODE NUMBER
COMMAND
VARCHAR2(161)
CURRENT_STATE
VARCHAR2(32)
COMPLETED_ACTIONS
NUMBER
TOTAL_ACTIONS
NUMBER
LOADED
VARCHAR2(7)
PERCENT_DONE
NUMBER
V$LOGMNR_LATCH: Synonym for V_$LOGMNR_LATCH
iSelfSchooling-SQL> desc V$LOGMNR_LATCH;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_ID
NUMBER
NAME
VARCHAR2(32)
CHILD_ADDR
RAW(8)
STATE
VARCHAR2(6)
V$LOGMNR_LOGFILE: Synonym for V_$LOGMNR_LOGFILE
iSelfSchooling-SQL> desc V$LOGMNR_LOGFILE;
Name
Null? Type
----------------------------- -------- --------------------
LOG_ID
NUMBER
FILENAME
VARCHAR2(513)
LOW_TIME
NUMBER
NEXT_TIME
NUMBER
DB_ID
NUMBER
DB_NAME
VARCHAR2(8)
RESET_SCNWRP
NUMBER
RESET_SCNBAS
NUMBER
RESET_SCN_TIME
NUMBER
THREAD_ID
NUMBER
THREAD_SQN
NUMBER
LOW_SCNWRP
NUMBER
LOW_SCNBAS
NUMBER
NEXT_SCNWRP
NUMBER
NEXT_SCNBAS
NUMBER
FILE_STATE
VARCHAR2(13)
V$LOGMNR_LOGS: Synonym for V_$LOGMNR_LOGS
iSelfSchooling-SQL> desc V$LOGMNR_LOGS;
Name
Null?
Type
----------------------------- -------- --------------------
LOG_ID
NUMBER
FILENAME
VARCHAR2(512)
LOW_TIME
DATE
HIGH_TIME |