dba_log_groups
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
SEE CODE DEPOT FOR FULL SCRIPT
/