Keyword: LOG
jump to Columns back to indexTables
| Table Name | Description |
|---|---|
| ALL_LOG_GROUPS | Log group definitions on accessible tables |
| ALL_LOG_GROUP_COLUMNS | Information about columns in log group definitions |
| ALL_MVIEW_LOGS | All materialized view logs in the database that the user can see |
| ALL_SNAPSHOT_LOGS | All snapshot logs in the database that the user can see |
| DBA_LOGSTDBY_LOG | List the information about received logs from the primary |
| DBA_LOG_GROUPS | Log group definitions on all tables |
| DBA_LOG_GROUP_COLUMNS | Information about columns in log group definitions |
| DBA_MVIEW_LOGS | All materialized view logs in the database |
| DBA_MVIEW_LOG_FILTER_COLS | All filter columns (excluding PK cols) being logged in the materialized view logs |
| DBA_SNAPSHOT_LOGS | All snapshot logs in the database |
| DBA_SNAPSHOT_LOG_FILTER_COLS | Synonym for DBA_MVIEW_LOG_FILTER_COLS |
| GV$ARCHIVED_LOG | Synonym for GV_$ARCHIVED_LOG |
| GV$LOG | Synonym for GV_$LOG |
| GV$LOGMNR_LOGS | Synonym for GV_$LOGMNR_LOGS |
| GV$LOG_HISTORY | Synonym for GV_$LOG_HISTORY |
| GV$RECOVERY_LOG | Synonym for GV_$RECOVERY_LOG |
| GV$STANDBY_LOG | Synonym for GV_$STANDBY_LOG |
| USER_LOG_GROUPS | Log group definitions on user's own tables |
| USER_LOG_GROUP_COLUMNS | Information about columns in log group definitions |
| USER_MVIEW_LOGS | All materialized view logs owned by the user |
| USER_SNAPSHOT_LOGS | All snapshot logs owned by the user |
| V$ARCHIVED_LOG | Synonym for V_$ARCHIVED_LOG |
| V$LOG | Synonym for V_$LOG |
| V$LOGMNR_LOGS | Synonym for V_$LOGMNR_LOGS |
| V$LOG_HISTORY | Synonym for V_$LOG_HISTORY |
| V$RECOVERY_LOG | Synonym for V_$RECOVERY_LOG |
| V$STANDBY_LOG | Synonym for V_$STANDBY_LOG |
Columns
| Column Name | Description |
|---|---|
| CAN_USE_LOG (DBA_SNAPSHOTS) | If NO, this snapshot is complex and will never use a log |
| CAN_USE_LOG (ALL_REGISTERED_SNAPSHOTS) | If NO, this snapshot is complex and cannot fast refresh |
| CAN_USE_LOG (ALL_SNAPSHOTS) | If NO, this snapshot is complex and will never use a log |
| CAN_USE_LOG (USER_SNAPSHOTS) | If NO, this snapshot is complex and will never use a log |
| CAN_USE_LOG (USER_REGISTERED_MVIEWS) | If NO, this materialized view is complex and cannot fast refresh |
| CAN_USE_LOG (DBA_REGISTERED_SNAPSHOTS) | If NO, this snapshot is complex and cannot fast refresh |
| CAN_USE_LOG (DBA_REGISTERED_MVIEWS) | If NO, this materialized view is complex and cannot fast refresh |
| CAN_USE_LOG (USER_REGISTERED_SNAPSHOTS) | If NO, this snapshot is complex and cannot fast refresh |
| CAN_USE_LOG (ALL_REGISTERED_MVIEWS) | If NO, this materialized view is complex and cannot fast refresh |
| DEF_LOGGING (ALL_PART_TABLES) | |
| DEF_LOGGING (DBA_PART_LOBS) | |
| DEF_LOGGING (DBA_PART_TABLES) | |
| DEF_LOGGING (USER_PART_TABLES) | |
| DEF_LOGGING (USER_PART_LOBS) | |
| DEF_LOGGING (ALL_PART_INDEXES) | |
| DEF_LOGGING (USER_PART_INDEXES) | |
| DEF_LOGGING (DBA_PART_INDEXES) | |
| DEF_LOGGING (ALL_PART_LOBS) | |
| FORCE_LOGGING (USER_TABLESPACES) | Tablespace force logging mode |
| FORCE_LOGGING (DBA_TABLESPACES) | Tablespace force logging mode |
| FORCE_LOGGING (GV$DATABASE) | |
| FORCE_LOGGING (V$DATABASE) | |
| LOGGING (USER_LOB_PARTITIONS) | |
| LOGGING (DBA_TABLES) | Logging attribute |
| LOGGING (TABS) | Logging attribute |
| LOGGING (ALL_IND_SUBPARTITIONS) | |
| LOGGING (USER_INDEXES) | Logging attribute |
| LOGGING (ALL_ALL_TABLES) | Logging attribute |
| LOGGING (USER_TABLESPACES) | Default logging attribute |
| LOGGING (USER_IND_PARTITIONS) | |
| LOGGING (USER_OBJECT_TABLES) | Logging attribute |
| LOGGING (ALL_TAB_PARTITIONS) | |
| LOGGING (DBA_IND_PARTITIONS) | |
| LOGGING (DBA_TABLESPACES) | Default logging attribute |
| LOGGING (ALL_LOB_SUBPARTITIONS) | |
| LOGGING (DBA_TAB_PARTITIONS) | |
| LOGGING (IND) | Logging attribute |
| LOGGING (ALL_IND_PARTITIONS) | |
| LOGGING (USER_LOB_SUBPARTITIONS) | |
| LOGGING (ALL_LOBS) | Are changes to the LOB logged? |
| LOGGING (USER_ALL_TABLES) | Logging attribute |
| LOGGING (DBA_LOBS) | Are changes to the LOB logged? |
| LOGGING (ALL_INDEXES) | Logging attribute |
| LOGGING (DBA_LOB_PARTITIONS) | |
| LOGGING (USER_IND_SUBPARTITIONS) | |
| LOGGING (DBA_LOB_SUBPARTITIONS) | |
| LOGGING (USER_LOBS) | Are changes to the LOB logged? |
| LOGGING (ALL_LOB_PARTITIONS) | |
| LOGGING (DBA_INDEXES) | Logging attribute |
| LOGGING (USER_TABLES) | Logging attribute |
| LOGGING (ALL_TABLES) | Logging attribute |
| LOGGING (DBA_ALL_TABLES) | Logging attribute |
| LOGGING (DBA_IND_SUBPARTITIONS) | |
| LOGGING (USER_TAB_PARTITIONS) | |
| LOGGING (DBA_OBJECT_TABLES) | Logging attribute |
| LOGGING (USER_TAB_SUBPARTITIONS) | |
| LOGGING (ALL_TAB_SUBPARTITIONS) | |
| LOGGING (ALL_OBJECT_TABLES) | Logging attribute |
| LOGGING (DBA_TAB_SUBPARTITIONS) | |
| LOG_CHKPT_INTERVAL_REDO_BLKS (V$INSTANCE_RECOVERY) | |
| LOG_CHKPT_INTERVAL_REDO_BLKS (GV$INSTANCE_RECOVERY) | |
| LOG_CHKPT_TIMEOUT_REDO_BLKS (V$INSTANCE_RECOVERY) | |
| LOG_CHKPT_TIMEOUT_REDO_BLKS (GV$INSTANCE_RECOVERY) | |
| LOG_FILE_SIZE_REDO_BLKS (GV$INSTANCE_RECOVERY) | |
| LOG_FILE_SIZE_REDO_BLKS (V$INSTANCE_RECOVERY) | |
| LOG_GROUP_NAME (USER_LOG_GROUP_COLUMNS) | Name associated with the log group definition |
| LOG_GROUP_NAME (USER_LOG_GROUPS) | Name associated with log group definition |
| LOG_GROUP_NAME (ALL_LOG_GROUPS) | Name associated with log group definition |
| LOG_GROUP_NAME (DBA_LOG_GROUP_COLUMNS) | Name associated with the log group definition |
| LOG_GROUP_NAME (DBA_LOG_GROUPS) | Name associated with log group definition |
| LOG_GROUP_NAME (ALL_LOG_GROUP_COLUMNS) | Name associated with the log group definition |
| LOG_ID (V$LOGMNR_LOGFILE) | |
| LOG_ID (DBA_REPDDL) | Identifying number of the repcat log record |
| LOG_ID (GV$LOGMNR_LOGS) | |
| LOG_ID (GV$LOGMNR_LOGFILE) | |
| LOG_ID (V$LOGMNR_CONTENTS) | |
| LOG_ID (GV$LOGMNR_CONTENTS) | |
| LOG_ID (ALL_REPDDL) | Identifying number of the repcat log record |
| LOG_ID (USER_REPDDL) | Identifying number of the repcat log record |
| LOG_ID (V$LOGMNR_LOGS) | |
| LOG_IO (V$TRANSACTION) | |
| LOG_IO (GV$TRANSACTION) | |
| LOG_MODE (V$DATABASE) | |
| LOG_MODE (GV$DATABASE) | |
| LOG_OWNER (ALL_MVIEW_LOGS) | Owner of the materialized view log |
| LOG_OWNER (DBA_SNAPSHOT_LOGS) | Owner of the snapshot log |
| LOG_OWNER (USER_MVIEW_LOGS) | Owner of the materialized view log |
| LOG_OWNER (ALL_SNAPSHOT_LOGS) | Owner of the snapshot log |
| LOG_OWNER (USER_SNAPSHOT_LOGS) | Owner of the snapshot log |
| LOG_OWNER (DBA_MVIEW_LOGS) | Owner of the materialized view log |
| LOG_SEQUENCE (GV$ARCHIVE_DEST) | |
| LOG_SEQUENCE (GV$ARCHIVE_PROCESSES) | |
| LOG_SEQUENCE (V$ARCHIVE_PROCESSES) | |
| LOG_SEQUENCE (V$ARCHIVE_DEST) | |
| LOG_SWITCH_WAIT (GV$INSTANCE) | |
| LOG_SWITCH_WAIT (V$INSTANCE) | |
| LOG_TABLE (ALL_MVIEW_LOGS) | Log table; with rowids and timestamps of rows which changed in the master |
| LOG_TABLE (ALL_SNAPSHOT_LOGS) | Log table; with rowids and timestamps of rows which changed in the master |
| LOG_TABLE (DBA_SNAPSHOT_LOGS) | Log table; with rowids and timestamps of rows which changed in the master |
| LOG_TABLE (USER_MVIEW_LOGS) | Log table; with rowids and timestamps of rows which changed in the master |
| LOG_TABLE (DBA_MVIEW_LOGS) | Log table; with rowids and timestamps of rows which changed in the master |
| LOG_TABLE (USER_SNAPSHOT_LOGS) | Log table; with rowids and timestamps of rows which changed in the master |
| LOG_TRIGGER (DBA_MVIEW_LOGS) | An after-row trigger on the master which inserts rows into the log |
| LOG_TRIGGER (ALL_MVIEW_LOGS) | An after-row trigger on the master which inserts rows into the log |
| LOG_TRIGGER (DBA_SNAPSHOT_LOGS) | An after-row trigger on the master which inserts rows into the log |
| LOG_TRIGGER (USER_SNAPSHOT_LOGS) | Trigger on master table; fills the snapshot log |
| LOG_TRIGGER (USER_MVIEW_LOGS) | Trigger on master table; fills the materialized view log |
| LOG_TRIGGER (ALL_SNAPSHOT_LOGS) | An after-row trigger on the master which inserts rows into the log |
| LOG_USER (DBA_JOBS) | USER who was logged in when the job was submitted |
| LOG_USER (ALL_JOBS) | USER who was logged in when the job was submitted |
| LOG_USER (USER_JOBS) | USER who was logged in when the job was submitted |
| PREVIOUS_LOG_NAME (V$RECOVERY_STATUS) | |
| PREVIOUS_LOG_NAME (GV$RECOVERY_STATUS) | |
| PREVIOUS_LOG_STATUS (GV$RECOVERY_STATUS) | |
| PREVIOUS_LOG_STATUS (V$RECOVERY_STATUS) | |
| SUPPLEMENTAL_LOG_DATA_MIN (GV$DATABASE) | |
| SUPPLEMENTAL_LOG_DATA_MIN (V$DATABASE) | |
| SUPPLEMENTAL_LOG_DATA_PK (GV$DATABASE) | |
| SUPPLEMENTAL_LOG_DATA_PK (V$DATABASE) | |
| SUPPLEMENTAL_LOG_DATA_UI (V$DATABASE) | |
| SUPPLEMENTAL_LOG_DATA_UI (GV$DATABASE) | |
| UPDATE_LOG (ALL_SNAPSHOTS) | The table which logs changes made to an updatable snapshots |
| UPDATE_LOG (DBA_SNAPSHOTS) | The table which logs changes made to an updatable snapshots |
| UPDATE_LOG (USER_SNAPSHOTS) | The table which logs changes made to an updatable snapshots |
| UPDATE_LOG (DBA_MVIEWS) | Name of the table that logs changes to an updatable materialized view |
| UPDATE_LOG (USER_MVIEWS) | Name of the table that logs changes to an updatable materialized view |
| UPDATE_LOG (ALL_MVIEWS) | Name of the table that logs changes to an updatable materialized view |