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
DATE
DB_ID
NUMBER
DB_NAME
VARCHAR2(8)
RESET_SCN
NUMBER
RESET_SCN_TIME
DATE
THREAD_ID
NUMBER
THREAD_SQN
NUMBER
LOW_SCN
NUMBER
NEXT_SCN
NUMBER
DICTIONARY_BEGIN
VARCHAR2(3)
DICTIONARY_END
VARCHAR2(3)
TYPE
VARCHAR2(7)
BLOCKSIZE
NUMBER
FILESIZE
NUMBER
INFO
VARCHAR2(32)
STATUS
NUMBER
V$LOGMNR_PARAMETERS: Synonym for V_$LOGMNR_PARAMETERS
iSelfSchooling-SQL> desc V$LOGMNR_PARAMETERS;
Name
Null? Type
----------------------------- -------- --------------------
START_DATE
DATE
REQUIRED_START_DATE
DATE
END_DATE
DATE
START_SCN
NUMBER
REQUIRED_START_SCN
NUMBER
END_SCN
NUMBER
OPTIONS
NUMBER
INFO
VARCHAR2(32)
STATUS
NUMBER
V$LOGMNR_PROCESS: Synonym for V_$LOGMNR_PROCESS
iSelfSchooling-SQL> desc V$LOGMNR_PROCESS;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_ID
NUMBER
PID
NUMBER
SPID
VARCHAR2(12)
ROLE
VARCHAR2(32)
USERNAME
VARCHAR2(15)
SID
NUMBER
SERIAL#
NUMBER
LATCHWAIT
VARCHAR2(16)
LATCHSPIN
VARCHAR2(16)
WORK_MICROSEC
VARCHAR2(21)
OVERHEAD_MICROSEC
VARCHAR2(21)
V$LOGMNR_REGION: Synonym for V_$LOGMNR_REGION
iSelfSchooling-SQL> desc V$LOGMNR_REGION;
Name
Null? Type
----------------------------- -------- --------------------
MEMSTATE
NUMBER
STATE
VARCHAR2(9)
OWNING_PROCESS
NUMBER
V$LOGMNR_SESSION: Synonym for V_$LOGMNR_SESSION
iSelfSchooling-SQL> desc V$LOGMNR_SESSION;
Name
Null? Type
----------------------------- -------- --------------------
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
V$LOGMNR_STATS: Synonym for V_$LOGMNR_STATS
iSelfSchooling-SQL> desc V$LOGMNR_STATS;
Name
Null? Type
----------------------------- -------- --------------------
SESSION_ID
NUMBER
NAME
VARCHAR2(32)
VALUE
VARCHAR2(21)
V$LOGMNR_TRANSACTION: Synonym for V_$LOGMNR_TRANSACTION
iSelfSchooling-SQL> desc V$LOGMNR_TRANSACTION;
Name
Null? Type
----------------------------- -------- --------------------
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)
V$LOGSTDBY: Synonym for V_$LOGSTDBY
iSelfSchooling-SQL> desc V$LOGSTDBY;
Name
Null? Type
----------------------------- -------- --------------------
SERIAL#
NUMBER
LOGSTDBY_ID
NUMBER
PID
VARCHAR2(12)
TYPE
VARCHAR2(30)
STATUS_CODE
NUMBER
STATUS
VARCHAR2(256)
HIGH_SCN
NUMBER
V$LOGSTDBY_PROCESS: Synonym for V_$LOGSTDBY_PROCESS
iSelfSchooling-SQL> desc V$LOGSTDBY_PROCESS;
Name
Null? Type
----------------------------- -------- --------------------
SID
NUMBER
SERIAL#
NUMBER
LOGSTDBY_ID
NUMBER
SPID
VARCHAR2(12)
TYPE
VARCHAR2(30)
STATUS_CODE
NUMBER
STATUS
VARCHAR2(256)
HIGH_SCN
NUMBER
V$LOGSTDBY_PROGRESS: Synonym for V_$LOGSTDBY_PROGRESS
iSelfSchooling-SQL> desc V$LOGSTDBY_PROGRESS;
Name
Null? Type
----------------------------- -------- --------------------
APPLIED_SCN
NUMBER
APPLIED_TIME
DATE
RESTART_SCN
NUMBER
RESTART_TIME
DATE
LATEST_SCN
NUMBER
LATEST_TIME
DATE
MINING_SCN
NUMBER
MINING_TIME
DATE
V$LOGSTDBY_STATE: Synonym for V_$LOGSTDBY_STATE
iSelfSchooling-SQL> desc V$LOGSTDBY_STATE;
Name
Null?
Type
----------------------------- -------- --------------------
PRIMARY_DBID
NUMBER
SESSION_ID
NUMBER
REALTIME_APPLY
VARCHAR2(64)
STATE
VARCHAR2(64)
V$LOGSTDBY_STATS: Synonym for V_$LOGSTDBY_STATS
iSelfSchooling-SQL> desc
V$LOGSTDBY_STATS;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(64)
VALUE
VARCHAR2(64)
V$LOGSTDBY_TRANSACTION: Synonym for V_$LOGSTDBY_TRANSACTION
iSelfSchooling-SQL> desc V$LOGSTDBY_TRANSACTION;
Name
Null? Type
----------------------------- -------- --------------------
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
V$LOG_HISTORY: Synonym for V_$LOG_HISTORY
iSelfSchooling-SQL> desc V$LOG_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
RECID
NUMBER
STAMP
NUMBER
THREAD#
NUMBER
SEQUENCE#
NUMBER
FIRST_CHANGE#
NUMBER
FIRST_TIME
DATE
NEXT_CHANGE#
NUMBER
RESETLOGS_CHANGE#
NUMBER
RESETLOGS_TIME
DATE
V$MANAGED_STANDBY: Synonym for V_$MANAGED_STANDBY
iSelfSchooling-SQL> desc V$MANAGED_STANDBY;
Name
Null? Type
----------------------------- -------- --------------------
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
V$MAP_COMP_LIST: Synonym for V_$MAP_COMP_LIST
iSelfSchooling-SQL> desc V$MAP_COMP_LIST;
Name
Null? Type
----------------------------- -------- --------------------
ELEM_IDX
NUMBER
NUM_COMP
NUMBER
COMP1_NAME
VARCHAR2(256)
COMP1_VAL
VARCHAR2(256)
COMP2_NAME
VARCHAR2(256)
COMP2_VAL
VARCHAR2(256)
COMP3_NAME
VARCHAR2(256)
COMP3_VAL
VARCHAR2(256)
COMP4_NAME
VARCHAR2(256)
COMP4_VAL
VARCHAR2(256)
COMP5_NAME
VARCHAR2(256)
COMP5_VAL
VARCHAR2(256)
V$MAP_ELEMENT: Synonym for V_$MAP_ELEMENT
iSelfSchooling-SQL> desc V$MAP_ELEMENT;
Name
Null? Type
----------------------------- -------- --------------------
ELEM_NAME
VARCHAR2(256)
ELEM_IDX
NUMBER
ELEM_CFGID
VARCHAR2(256)
ELEM_TYPE
VARCHAR2(12)
ELEM_SIZE
NUMBER
ELEM_NSUBELEM
NUMBER
ELEM_DESCR
VARCHAR2(256)
STRIPE_SIZE
NUMBER
LIB_IDX
NUMBER
V$MAP_EXT_ELEMENT: Synonym for V_$MAP_EXT_ELEMENT
iSelfSchooling-SQL> desc V$MAP_EXT_ELEMENT;
Name
Null? Type
----------------------------- -------- --------------------
ELEM_IDX
NUMBER
NUM_ATTRB
NUMBER
ATTRB1_NAME
VARCHAR2(256)
ATTRB1_VAL
VARCHAR2(256)
ATTRB2_NAME
VARCHAR2(256)
ATTRB2_VAL
VARCHAR2(256)
ATTRB3_NAME
VARCHAR2(256)
ATTRB3_VAL
VARCHAR2(256)
ATTRB4_NAME
VARCHAR2(256)
ATTRB4_VAL
VARCHAR2(256)
ATTRB5_NAME
VARCHAR2(256)
ATTRB5_VAL
VARCHAR2(256)
V$MAP_FILE: Synonym for V_$MAP_FILE
iSelfSchooling-SQL> desc V$MAP_FILE;
Name
Null? Type
----------------------------- -------- --------------------
FILE_MAP_IDX
NUMBER
FILE_CFGID
VARCHAR2(256)
FILE_STATUS
VARCHAR2(7)
FILE_NAME
VARCHAR2(256)
FILE_TYPE
VARCHAR2(11)
FILE_STRUCTURE
VARCHAR2(9)
FILE_SIZE
NUMBER
FILE_NEXTS
NUMBER
LIB_IDX
NUMBER
V$MAP_FILE_EXTENT: Synonym for V_$MAP_FILE_EXTENT
iSelfSchooling-SQL> desc V$MAP_FILE_EXTENT;
Name
Null? Type
----------------------------- -------- --------------------
FILE_MAP_IDX
NUMBER
EXT_NUM
NUMBER
EXT_ELEM_OFF
NUMBER
EXT_SIZE
NUMBER
EXT_FILE_OFF
NUMBER
EXT_TYPE
VARCHAR2(6)
ELEM_IDX
NUMBER
V$MAP_FILE_IO_STACK: Synonym for V_$MAP_FILE_IO_STACK
iSelfSchooling-SQL> desc V$MAP_FILE_IO_STACK;
Name
Null? Type
----------------------------- -------- --------------------
FILE_MAP_IDX
NUMBER
DEPTH
NUMBER
ELEM_IDX
NUMBER
CU_SIZE
NUMBER
STRIDE
NUMBER
NUM_CU
NUMBER
ELEM_OFFSET
NUMBER
FILE_OFFSET
NUMBER
DATA_TYPE
VARCHAR2(15)
PARITY_POS
NUMBER
PARITY_PERIOD
NUMBER
ID
NUMBER
PARENT_ID
NUMBER
V$MAP_LIBRARY: Synonym for V_$MAP_LIBRARY
iSelfSchooling-SQL> desc V$MAP_LIBRARY;
Name
Null? Type
----------------------------- -------- --------------------
LIB_IDX
NUMBER
LIB_NAME
VARCHAR2(256)
VENDOR_NAME
VARCHAR2(64)
PROTOCOL_NUM
NUMBER
VERSION_NUM
VARCHAR2(32)
PATH_NAME
VARCHAR2(1024)
MAP_FILE
VARCHAR2(1)
FILE_CFGID
VARCHAR2(13)
MAP_ELEM
VARCHAR2(1)
ELEM_CFGID
VARCHAR2(13)
MAP_SYNC
VARCHAR2(1)
V$MAP_SUBELEMENT: Synonym for V_$MAP_SUBELEMENT
iSelfSchooling-SQL> desc V$MAP_SUBELEMENT;
Name
Null?
Type
----------------------------- -------- --------------------
CHILD_IDX
NUMBER
PARENT_IDX
NUMBER
SUB_NUM
NUMBER
SUB_SIZE
NUMBER
ELEM_OFFSET
NUMBER
SUB_FLAGS
NUMBER
V$MAX_ACTIVE_SESS_TARGET_MTH: Synonym for
V_$MAX_ACTIVE_SESS_TARGET_MTH
iSelfSchooling-SQL> desc V$MAX_ACTIVE_SESS_TARGET_MTH;
Name
Null? Type
----------------------------- -------- --------------------
NAME
VARCHAR2(40)
V$METRIC: Synonym for V_$METRIC
iSelfSchooling-SQL> desc V$METRIC;
Name
Null? Type
----------------------------- -------- --------------------
BEGIN_TIME
DATE
END_TIME
DATE
INTSIZE_CSEC
NUMBER
GROUP_ID
NUMBER
ENTITY_ID
NUMBER
ENTITY_SEQUENCE
NUMBER
METRIC_ID
NUMBER
METRIC_NAME
VARCHAR2(64)
VALUE
NUMBER
METRIC_UNIT
VARCHAR2(64)
V$METRICGROUP: Synonym for V_$METRICGROUP
iSelfSchooling-SQL> desc V$METRICGROUP;
Name
Null? Type
----------------------------- -------- --------------------
GROUP_ID
NUMBER
NAME
VARCHAR2(64)
INTERVAL_SIZE
NUMBER
MAX_INTERVAL
NUMBER
V$METRICNAME: Synonym for V_$METRICNAME
iSelfSchooling-SQL> desc V$METRICNAME;
Name
Null?
Type
----------------------------- -------- --------------------
GROUP_ID
NUMBER
GROUP_NAME
VARCHAR2(64)
METRIC_ID
NUMBER
METRIC_NAME
VARCHAR2(64)
METRIC_UNIT
VARCHAR2(64)
V$METRIC_HISTORY: Synonym for V_$METRIC_HISTORY
iSelfSchooling-SQL> desc V$METRIC_HISTORY;
Name
Null? Type
----------------------------- -------- --------------------
BEGIN_TIME
DATE
END_TIME
DATE
INTSIZE_CSEC
NUMBER
GROUP_ID
NUMBER
ENTITY_ID
NUMBER
ENTITY_SEQUENCE
NUMBER
METRIC_ID
NUMBER
METRIC_NAME
VARCHAR2(64)
VALUE
NUMBER
METRIC_UNIT
VARCHAR2(64)
|