DBA_LOG_GROUPS view tips

Oracle Tips by Burleson Consulting

DBA_LOG_GROUPS

<< Return to the index

Oracle 11g makes the following comments about the DBA_LOG_GROUPS table: "Log group definitions on all tables"

Related notes on DBA_LOG_GROUPS:

Oracle DBA View List

Column description of the DBA_LOG_GROUPS view:

OWNER

Description of DBA_LOG_GROUPS.OWNER: "Owner of the table"

LOG_GROUP_NAME

Description of DBA_LOG_GROUPS.LOG_GROUP_NAME: "Name associated with log group definition"

TABLE_NAME

No comments exist for the TABLE_NAME column of the DBA_LOG_GROUPS table.

LOG_GROUP_TYPE

No comments exist for the LOG_GROUP_TYPE column of the DBA_LOG_GROUPS table.

ALWAYS

Description of DBA_LOG_GROUPS.ALWAYS: "Is this an ALWAYS or a CONDITIONAL supplemental log group?"

GENERATED

Description of DBA_LOG_GROUPS.GENERATED: "Was the name of this supplemental log group system generated?"

DBA_LOG_GROUPS View Source

Oracle 11g's data dictionary defines the DBA_LOG_GROUPS view using the following source query:

select ou.name, oc.name, o.name,
case c.type# when 14 then 'PRIMARY KEY LOGGING'
when 15 then 'UNIQUE KEY LOGGING'
when 16 then 'FOREIGN KEY LOGGING'
when 17 then 'ALL COLUMN LOGGING'
else 'USER LOG GROUP'
end,
case bitand(c.defer,64) when 64 then 'ALWAYS'
else 'CONDITIONAL'
end,
case bitand(c.defer,8) when 8 then 'GENERATED NAME'
else 'USER NAME'
end
from sys.con$ oc, sys.user$ ou, sys.obj$ o, sys.cdef$ c
where oc.owner# = ou.user#
and oc.con# = c.con#
and c.obj# = o.obj#
and
(c.type# = 12 or c.type# = 14 or
c.type# = 15 or c.type# = 16 or
c.type# = 17)

If you like Oracle tuning, see the book "Oracle Tuning: The Definitive Reference", with 950 pages of tuning tips and scripts.
You can buy it direct from the publisher for 30%-off and get instant access to the code depot of Oracle tuning scripts.

Download your Oracle scripts now:

www.oracle-script.com

The definitive Oracle Script collection for every Oracle professional DBA

Oracle performance Tuning 10g reference poster

Oracle training & performance tuning books