模板
教程
环境
性能
功能
管理
关于logmnr的相关的表
发表于：2007-05-26来源：作者：点击数：
标签：
V$LOGMNR_CONTENTS Data Dictionary View Columns ___________________________ SCN CSCN TIMESTAMP COM MI T_TIMESTAMP THREAD# LOG_ID XIDUSN XIDSLT XIDSQN PXIDUSN PXIDSLT PXIDSQN RBASQN RBABLK RBABYTE UBAFIL UBABLK UBAREC UBASQN ABS_FILE# REL_FI
V$LOGMNR_CONTENTS
Data Dictionary View
Columns ___________________________ SCN CSCN TIMESTAMP COMMIT_TIMESTAMP THREAD# LOG_ID XIDUSN XIDSLT XIDSQN PXIDUSN PXIDSLT PXIDSQN RBASQN RBABLK RBABYTE UBAFIL UBABLK UBAREC UBASQN ABS_FILE# REL_FILE# DATA_BLK# DATA_OBJ# DATA_OBJD# SEG_OWNER SEG_NAME SEG_TYPE SEG_TYPE_NAME TABLE_SPACE ROW_ID SESSION# SERIAL# USERNAME SESSION_INFO TX_NAME ROLLBACK OPERATION OPERATION_CODE SQL_REDO SQL_UNDO RS_ID SEQUENCE# SSN CSF INFO STATUS REDO_VALUE UNDO_VALUE SQL_COLUMN_TYPE SQL_COLUMN_NAME REDO_LENGTH REDO_OFFSET UNDO_LENGTH UNDO_OFFSET
V$LOGMNR_DICTIONARY
Data Dictionary View
Columns ___________________________ TIMESTAMP DB_ID DB_NAME FILENAME DICTIONARY_SCN RESET_SCN RESET_SCN_TIME ENABLED_THREAD_MAP INFO STATUSV$LOGMNR_LOGFILE
Data Dictionary ViewColumns ___________________________ LOG_ID FILENAME LOW_TIME NEXT_TIME DB_ID DB_NAME RESET_SCNWRP RESET_SCNBAS RESET_SCN_TIME THREAD_ID THREAD_SQN LOW_SCNWRP LOW_SCNBAS NEXT_SCNWRP NEXT_SCNBAS FILE_STATEV$LOGMNR_LOGS
Data Dictionary ViewColumns ___________________________ LOG_ID FILENAME LOW_TIME HIGH_TIME DB_ID DB_NAME RESET_SCN RESET_SCN_TIME THREAD_ID THREAD_SQN LOW_SCN NEXT_SCN DICTIONARY_BEGIN DICTIONARY_END INFO STATUSV$LOGMNR_PARAMETERS
Data Dictionary ViewColumns ___________________________ END_SCN INFO STATUS START_DATE END_DATE START_SCNV$LOGMNR_PROCESS
Data Dictionary ViewColumns ___________________________ PID SPID ROLE USERNAME SERIAL# LATCHWAIT LATCHSPINV$LOGMNR_REGION
Data Dictionary View
Columns ___________________________ MEMSTATE STATE OWNING_PROCESSV$LOGMNR_SESSION
Data Dictionary ViewColumns ___________________________ SESSION_ID SESSION_NAME SESSION_STATE START_SCNWRP START_SCNBAS END_SCNWRP END_SCNBAS SPILL_SCNWRP SPILL_SCNBAS REQUIRED_SLAVE_NUM EAGER_THRESHOLD STOPMINING_THRESHOLD MEMORY_SIZE CLIENT_ID DB_ID RESET_SCNWRP RESET_SCNBAS CALLBACK_COUNT SLAVE_COUNTV$LOGMNR_STATS
Data Dictionary ViewColumns ___________________________ SESSION_ID NAME VALUEV$LOGMNR_TRANSACTION
Data Dictionary ViewColumns ___________________________ XIDUSN XIDSLT XIDSQN COMMIT_SCNWRP COMMIT_SCNBAS NUM_CHANGE_RECORD FLAGS CHUNK_INDEX TOTAL_CHUNKS
