DBA_LOG_GROUP_COLUMNS view tips

Oracle Tips by Burleson Consulting

DBA_LOG_GROUP_COLUMNS

<< Return to the index

Oracle 11g makes the following comments about the DBA_LOG_GROUP_COLUMNS table: "Information about columns in log group definitions"

Related notes on DBA_LOG_GROUP_COLUMNS:

Oracle DBA View List

Column description of the DBA_LOG_GROUP_COLUMNS view:

OWNER

Description of DBA_LOG_GROUP_COLUMNS.OWNER: "Owner of the log group definition"

LOG_GROUP_NAME

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

TABLE_NAME

Description of DBA_LOG_GROUP_COLUMNS.TABLE_NAME: "Name associated with table with log group definition"

COLUMN_NAME

Description of DBA_LOG_GROUP_COLUMNS.COLUMN_NAME: "Name associated with column or attribute of object column specified in the log group definition"

POSITION

Description of DBA_LOG_GROUP_COLUMNS.POSITION: "Original position of column or attribute in definition"

LOGGING_PROPERTY

Description of DBA_LOG_GROUP_COLUMNS.LOGGING_PROPERTY: "Whether the column or attribute would be supplementally logged"

DBA_LOG_GROUP_COLUMNS View Source

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

select u.name, c.name, o.name,
decode(ac.name, null, col.name, ac.name), cc.pos#,
decode(cc.spare1, 1, 'NO LOG', 'LOG')
from sys.user$ u, sys.con$ c, sys.col$ col, sys.ccol$ cc, sys.cdef$ cd,
sys.obj$ o, sys.attrcol$ ac
where c.owner# = u.user#
and c.con# = cd.con#
and cd.type# = 12
and cd.con# = cc.con#
and cc.obj# = col.obj#
and cc.intcol# = col.intcol#
and cc.obj# = o.obj#
and col.obj# = ac.obj#(+)
and col.intcol# = ac.intcol#(+)

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