dba_log_groups Tips
This view describes the log group
definitions on the tables in the database. The following
statement can be used to list the supplemental log groups:
set linesize 140
COLUMN log_group_name FORMAT A30
COLUMN owner FORMAT A24
COLUMN table_name FORMAT A30
COLUMN always HEADING 'Type of Log Group'
FORMAT A30
SELECT log_group_name, owner, table_name,
DECODE(always, 'ALWAYS', 'Unconditional',
NULL, 'Conditional') ALWAYS
FROM DBA_LOG_GROUPS
/
The contents of this view show the
supplemental logging configured. This information helps to
troubleshoot apply issues.
dba_log_group_columns
This view describes all columns in the
database that are specified in log groups.
For example, to query
the columns in the group ALLINS1_LOG_GRP1, use the following SQL
statement:
col OWNER for a8
col LOG_GROUP_NAME for a20
col TABLE_NAME for a20
col COLUMN_NAME for a12
select *
from
dba_log_group_columns;
DBA_LOG_GROUPS
Log group definitions on all tables
------------------------------------------------------------------------------------
OWNER VARCHAR2 Owner of the table
LOG_GROUP_NAME VARCHAR2 Name associated with log group definition
TABLE_NAME VARCHAR2
LOG_GROUP_TYPE VARCHAR2
ALWAYS VARCHAR2 Is this an ALWAYS or a CONDITIONAL supplemental log group?
GENERATED VARCHAR2 Was the name of this supplemental log group system generated?
DBA_LOG_GROUP_COLUMNS
Information about columns in log group definitions
------------------------------------------------------------------------------------
OWNER VARCHAR2 Owner of the log group definition
LOG_GROUP_NAME VARCHAR2 Name associated with the log group definition
TABLE_NAME VARCHAR2 Name associated with table with log group definition
COLUMN_NAME VARCHAR2 Name associated with column or attribute of object column specified in the
log group definition
POSITION NUMBER Original position of column or attribute in definition
LOGGING_PROPERTY VARCHAR2 Whether the column or attribute would be supplementally logged