BC Oracle tuning

Oracle training

Oracle support

Remote Oracle

Redneck

DBA_OBJ_AUDIT_OPTS view tips

Oracle Tips by Burleson Consulting

DBA_OBJ_AUDIT_OPTS

<< Return to the index

Oracle 11g makes the following comments about the DBA_OBJ_AUDIT_OPTS table: "Auditing options for all tables and views with atleast one option set"

Related notes on DBA_OBJ_AUDIT_OPTS:

Column description of the DBA_OBJ_AUDIT_OPTS view:

OWNER

Description of DBA_OBJ_AUDIT_OPTS.OWNER: "Owner of the object"

OBJECT_NAME

Description of DBA_OBJ_AUDIT_OPTS.OBJECT_NAME: "Name of the object"

OBJECT_TYPE

Description of DBA_OBJ_AUDIT_OPTS.OBJECT_TYPE: "Type of the object"

ALT

Description of DBA_OBJ_AUDIT_OPTS.ALT: "Auditing ALTER WHENEVER SUCCESSFUL / UNSUCCESSFUL"

AUD

Description of DBA_OBJ_AUDIT_OPTS.AUD: "Auditing AUDIT WHENEVER SUCCESSFUL / UNSUCCESSFUL"

COM

Description of DBA_OBJ_AUDIT_OPTS.COM: "Auditing COMMENT WHENEVER SUCCESSFUL / UNSUCCESSFUL"

DEL

Description of DBA_OBJ_AUDIT_OPTS.DEL: "Auditing DELETE WHENEVER SUCCESSFUL / UNSUCCESSFUL"

GRA

Description of DBA_OBJ_AUDIT_OPTS.GRA: "Auditing GRANT WHENEVER SUCCESSFUL / UNSUCCESSFUL"

IND

Description of DBA_OBJ_AUDIT_OPTS.IND: "Auditing INDEX WHENEVER SUCCESSFUL / UNSUCCESSFUL"

INS

Description of DBA_OBJ_AUDIT_OPTS.INS: "Auditing INSERT WHENEVER SUCCESSFUL / UNSUCCESSFUL"

LOC

Description of DBA_OBJ_AUDIT_OPTS.LOC: "Auditing LOCK WHENEVER SUCCESSFUL / UNSUCCESSFUL"

REN

Description of DBA_OBJ_AUDIT_OPTS.REN: "Auditing RENAME WHENEVER SUCCESSFUL / UNSUCCESSFUL"

SEL

Description of DBA_OBJ_AUDIT_OPTS.SEL: "Auditing SELECT WHENEVER SUCCESSFUL / UNSUCCESSFUL"

UPD

Description of DBA_OBJ_AUDIT_OPTS.UPD: "Auditing UPDATE WHENEVER SUCCESSFUL / UNSUCCESSFUL"

REF

Description of DBA_OBJ_AUDIT_OPTS.REF: "Dummy REF column. Maintained for backward compatibility of the view"

EXE

Description of DBA_OBJ_AUDIT_OPTS.EXE: "Auditing EXECUTE WHENEVER SUCCESSFUL / UNSUCCESSFUL"

CRE

Description of DBA_OBJ_AUDIT_OPTS.CRE: "Auditing CREATE WHENEVER SUCCESSFUL / UNSUCCESSFUL"

REA

Description of DBA_OBJ_AUDIT_OPTS.REA: "Auditing READ WHENEVER SUCCESSFUL / UNSUCCESSFUL"

WRI

Description of DBA_OBJ_AUDIT_OPTS.WRI: "Auditing WRITE WHENEVER SUCCESSFUL / UNSUCCESSFUL"

FBK

Description of DBA_OBJ_AUDIT_OPTS.FBK: "Auditing FLASHBACK WHENEVER SUCCESSFUL / UNSUCCESSFUL"

DBA_OBJ_AUDIT_OPTS View Source

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

select u.name, o.name, 'TABLE',
substr(t.audit$, 1, 1) || '/' || substr(t.audit$, 2, 1),
substr(t.audit$, 3, 1) || '/' || substr(t.audit$, 4, 1),
substr(t.audit$, 5, 1) || '/' || substr(t.audit$, 6, 1),
substr(t.audit$, 7, 1) || '/' || substr(t.audit$, 8, 1),
substr(t.audit$, 9, 1) || '/' || substr(t.audit$, 10, 1),
substr(t.audit$, 11, 1) || '/' || substr(t.audit$, 12, 1),
substr(t.audit$, 13, 1) || '/' || substr(t.audit$, 14, 1),
substr(t.audit$, 15, 1) || '/' || substr(t.audit$, 16, 1),
substr(t.audit$, 17, 1) || '/' || substr(t.audit$, 18, 1),
substr(t.audit$, 19, 1) || '/' || substr(t.audit$, 20, 1),
substr(t.audit$, 21, 1) || '/' || substr(t.audit$, 22, 1),
'-/-', /* dummy REF column */
substr(t.audit$, 25, 1) || '/' || substr(t.audit$, 26, 1),
substr(t.audit$, 27, 1) || '/' || substr(t.audit$, 28, 1),
substr(t.audit$, 29, 1) || '/' || substr(t.audit$, 30, 1),
substr(t.audit$, 31, 1) || '/' || substr(t.audit$, 32, 1),
substr(t.audit$, 23, 1) || '/' || substr(t.audit$, 24, 1)
from sys.obj$ o, sys.user$ u, sys.tab$ t
where o.type# = 2
and not (o.owner# = 0 and o.name = '_default_auditing_options_')
and (instrb(t.audit$,'S') != 0 or instrb(t.audit$,'A') != 0)
and o.owner# = u.user#
and o.obj# = t.obj#
union all
select u.name, o.name, 'VIEW',
substr(v.audit$, 1, 1) || '/' || substr(v.audit$, 2, 1),
substr(v.audit$, 3, 1) || '/' || substr(v.audit$, 4, 1),
substr(v.audit$, 5, 1) || '/' || substr(v.audit$, 6, 1),
substr(v.audit$, 7, 1) || '/' || substr(v.audit$, 8, 1),
substr(v.audit$, 9, 1) || '/' || substr(v.audit$, 10, 1),
substr(v.audit$, 11, 1) || '/' || substr(v.audit$, 12, 1),
substr(v.audit$, 13, 1) || '/' || substr(v.audit$, 14, 1),
substr(v.audit$, 15, 1) || '/' || substr(v.audit$, 16, 1),
substr(v.audit$, 17, 1) || '/' || substr(v.audit$, 18, 1),
substr(v.audit$, 19, 1) || '/' || substr(v.audit$, 20, 1),
substr(v.audit$, 21, 1) || '/' || substr(v.audit$, 22, 1),
'-/-', /* dummy REF column */
substr(v.audit$, 25, 1) || '/' || substr(v.audit$, 26, 1),
substr(v.audit$, 27, 1) || '/' || substr(v.audit$, 28, 1),
substr(v.audit$, 29, 1) || '/' || substr(v.audit$, 30, 1),
substr(v.audit$, 31, 1) || '/' || substr(v.audit$, 32, 1),
substr(v.audit$, 23, 1) || '/' || substr(v.audit$, 24, 1)
from sys."_CURRENT_EDITION_OBJ" o, sys.user$ u, sys.view$ v
where o.type# = 4
and o.owner# = u.user#
and (instrb(v.audit$,'S') != 0 or instrb(v.audit$,'A') != 0)
and o.obj# = v.obj#
union all
select u.name, o.name, 'SEQUENCE',
substr(s.audit$, 1, 1) || '/' || substr(s.audit$, 2, 1),
substr(s.audit$, 3, 1) || '/' || substr(s.audit$, 4, 1),
substr(s.audit$, 5, 1) || '/' || substr(s.audit$, 6, 1),
substr(s.audit$, 7, 1) || '/' || substr(s.audit$, 8, 1),
substr(s.audit$, 9, 1) || '/' || substr(s.audit$, 10, 1),
substr(s.audit$, 11, 1) || '/' || substr(s.audit$, 12, 1),
substr(s.audit$, 13, 1) || '/' || substr(s.audit$, 14, 1),
substr(s.audit$, 15, 1) || '/' || substr(s.audit$, 16, 1),
substr(s.audit$, 17, 1) || '/' || substr(s.audit$, 18, 1),
substr(s.audit$, 19, 1) || '/' || substr(s.audit$, 20, 1),
substr(s.audit$, 21, 1) || '/' || substr(s.audit$, 22, 1),
'-/-', /* dummy REF column */
substr(s.audit$, 25, 1) || '/' || substr(s.audit$, 26, 1),
substr(s.audit$, 27, 1) || '/' || substr(s.audit$, 28, 1),
substr(s.audit$, 29, 1) || '/' || substr(s.audit$, 30, 1),
substr(s.audit$, 31, 1) || '/' || substr(s.audit$, 32, 1),
substr(s.audit$, 23, 1) || '/' || substr(s.audit$, 24, 1)
from sys.obj$ o, sys.user$ u, sys.seq$ s
where o.type# = 6
and o.owner# = u.user#
and (instrb(s.audit$,'S') != 0 or instrb(s.audit$,'A') != 0)
and o.obj# = s.obj#
union all
select u.name, o.name, 'PROCEDURE',
substr(p.audit$, 1, 1) || '/' || substr(p.audit$, 2, 1),
substr(p.audit$, 3, 1) || '/' || substr(p.audit$, 4, 1),
substr(p.audit$, 5, 1) || '/' || substr(p.audit$, 6, 1),
substr(p.audit$, 7, 1) || '/' || substr(p.audit$, 8, 1),
substr(p.audit$, 9, 1) || '/' || substr(p.audit$, 10, 1),
substr(p.audit$, 11, 1) || '/' || substr(p.audit$, 12, 1),
substr(p.audit$, 13, 1) || '/' || substr(p.audit$, 14, 1),
substr(p.audit$, 15, 1) || '/' || substr(p.audit$, 16, 1),
substr(p.audit$, 17, 1) || '/' || substr(p.audit$, 18, 1),
substr(p.audit$, 19, 1) || '/' || substr(p.audit$, 20, 1),
substr(p.audit$, 21, 1) || '/' || substr(p.audit$, 22, 1),
'-/-', /* dummy REF column */
substr(p.audit$, 25, 1) || '/' || substr(p.audit$, 26, 1),
substr(p.audit$, 27, 1) || '/' || substr(p.audit$, 28, 1),
substr(p.audit$, 29, 1) || '/' || substr(p.audit$, 30, 1),
substr(p.audit$, 31, 1) || '/' || substr(p.audit$, 32, 1),
substr(p.audit$, 23, 1) || '/' || substr(p.audit$, 24, 1)
from sys."_CURRENT_EDITION_OBJ" o, sys.user$ u, sys.library$ p
where o.type# = 22
and o.owner# = u.user#
and (instrb(p.audit$,'S') != 0 or instrb(p.audit$,'A') != 0)
and o.obj# = p.obj#
union all
select u.name, o.name, 'PROCEDURE',
substr(p.audit$, 1, 1) || '/' || substr(p.audit$, 2, 1),
substr(p.audit$, 3, 1) || '/' || substr(p.audit$, 4, 1),
substr(p.audit$, 5, 1) || '/' || substr(p.audit$, 6, 1),
substr(p.audit$, 7, 1) || '/' || substr(p.audit$, 8, 1),
substr(p.audit$, 9, 1) || '/' || substr(p.audit$, 10, 1),
substr(p.audit$, 11, 1) || '/' || substr(p.audit$, 12, 1),
substr(p.audit$, 13, 1) || '/' || substr(p.audit$, 14, 1),
substr(p.audit$, 15, 1) || '/' || substr(p.audit$, 16, 1),
substr(p.audit$, 17, 1) || '/' || substr(p.audit$, 18, 1),
substr(p.audit$, 19, 1) || '/' || substr(p.audit$, 20, 1),
substr(p.audit$, 21, 1) || '/' || substr(p.audit$, 22, 1),
'-/-', /* dummy REF column */
substr(p.audit$, 25, 1) || '/' || substr(p.audit$, 26, 1),
substr(p.audit$, 27, 1) || '/' || substr(p.audit$, 28, 1),
substr(p.audit$, 29, 1) || '/' || substr(p.audit$, 30, 1),
substr(p.audit$, 31, 1) || '/' || substr(p.audit$, 32, 1),
substr(p.audit$, 23, 1) || '/' || substr(p.audit$, 24, 1)
from sys."_CURRENT_EDITION_OBJ" o, sys.user$ u, sys.procedure$ p
where o.type# >= 7 and o.type# <= 9
and o.owner# = u.user#
and (instrb(p.audit$,'S') != 0 or instrb(p.audit$,'A') != 0)
and o.obj# = p.obj#
union all
select u.name, o.name, 'TYPE',
substr(t.audit$, 1, 1) || '/' || substr(t.audit$, 2, 1),
substr(t.audit$, 3, 1) || '/' || substr(t.audit$, 4, 1),
substr(t.audit$, 5, 1) || '/' || substr(t.audit$, 6, 1),
substr(t.audit$, 7, 1) || '/' || substr(t.audit$, 8, 1),
substr(t.audit$, 9, 1) || '/' || substr(t.audit$, 10, 1),
substr(t.audit$, 11, 1) || '/' || substr(t.audit$, 12, 1),
substr(t.audit$, 13, 1) || '/' || substr(t.audit$, 14, 1),
substr(t.audit$, 15, 1) || '/' || substr(t.audit$, 16, 1),
substr(t.audit$, 17, 1) || '/' || substr(t.audit$, 18, 1),
substr(t.audit$, 19, 1) || '/' || substr(t.audit$, 20, 1),
substr(t.audit$, 21, 1) || '/' || substr(t.audit$, 22, 1),
'-/-', /* dummy REF column */
substr(t.audit$, 25, 1) || '/' || substr(t.audit$, 26, 1),
substr(t.audit$, 27, 1) || '/' || substr(t.audit$, 28, 1),
substr(t.audit$, 29, 1) || '/' || substr(t.audit$, 30, 1),
substr(t.audit$, 31, 1) || '/' || substr(t.audit$, 32, 1),
substr(t.audit$, 23, 1) || '/' || substr(t.audit$, 24, 1)
from sys."_CURRENT_EDITION_OBJ" o, sys.user$ u, sys.type_misc$ t
where o.type# = 13
and o.owner# = u.user#
and (instrb(t.audit$,'S') != 0 or instrb(t.audit$,'A') != 0)
and o.obj# = t.obj#
union all
select u.name, o.name, 'DIRECTORY',
substr(t.audit$, 1, 1) || '/' || substr(t.audit$, 2, 1),
substr(t.audit$, 3, 1) || '/' || substr(t.audit$, 4, 1),
substr(t.audit$, 5, 1) || '/' || substr(t.audit$, 6, 1),
substr(t.audit$, 7, 1) || '/' || substr(t.audit$, 8, 1),
substr(t.audit$, 9, 1) || '/' || substr(t.audit$, 10, 1),
substr(t.audit$, 11, 1) || '/' || substr(t.audit$, 12, 1),
substr(t.audit$, 13, 1) || '/' || substr(t.audit$, 14, 1),
substr(t.audit$, 15, 1) || '/' || substr(t.audit$, 16, 1),
substr(t.audit$, 17, 1) || '/' || substr(t.audit$, 18, 1),
substr(t.audit$, 19, 1) || '/' || substr(t.audit$, 20, 1),
substr(t.audit$, 21, 1) || '/' || substr(t.audit$, 22, 1),
'-/-', /* dummy REF column */
substr(t.audit$, 25, 1) || '/' || substr(t.audit$, 26, 1),
substr(t.audit$, 27, 1) || '/' || substr(t.audit$, 28, 1),
substr(t.audit$, 29, 1) || '/' || substr(t.audit$, 30, 1),
substr(t.audit$, 31, 1) || '/' || substr(t.audit$, 32, 1),
substr(t.audit$, 23, 1) || '/' || substr(t.audit$, 24, 1)
from sys.obj$ o, sys.user$ u, sys.dir$ t
where o.type# = 23
and (instrb(t.audit$,'S') != 0 or instrb(t.audit$,'A') != 0)
and o.owner# = u.user#
and o.obj# = t.obj#
union all
select u.name, o.name,
decode(o.type#, 28, 'JAVA SOURCE',
29, 'JAVA CLASS',
30, 'JAVA RESOURCE',
'ILLEGAL JAVA TYPE'),
substr(t.audit$, 1, 1) || '/' || substr(t.audit$, 2, 1),
substr(t.audit$, 3, 1) || '/' || substr(t.audit$, 4, 1),
substr(t.audit$, 5, 1) || '/' || substr(t.audit$, 6, 1),
substr(t.audit$, 7, 1) || '/' || substr(t.audit$, 8, 1),
substr(t.audit$, 9, 1) || '/' || substr(t.audit$, 10, 1),
substr(t.audit$, 11, 1) || '/' || substr(t.audit$, 12, 1),
substr(t.audit$, 13, 1) || '/' || substr(t.audit$, 14, 1),
substr(t.audit$, 15, 1) || '/' || substr(t.audit$, 16, 1),
substr(t.audit$, 17, 1) || '/' || substr(t.audit$, 18, 1),
substr(t.audit$, 19, 1) || '/' || substr(t.audit$, 20, 1),
substr(t.audit$, 21, 1) || '/' || substr(t.audit$, 22, 1),
'-/-', /* dummy REF column */
substr(t.audit$, 25, 1) || '/' || substr(t.audit$, 26, 1),
substr(t.audit$, 27, 1) || '/' || substr(t.audit$, 28, 1),
substr(t.audit$, 29, 1) || '/' || substr(t.audit$, 30, 1),
substr(t.audit$, 31, 1) || '/' || substr(t.audit$, 32, 1),
substr(t.audit$, 23, 1) || '/' || substr(t.audit$, 24, 1)
from sys.obj$ o, sys.user$ u, sys.javaobj$ t
where (o.type# = 28 or o.type# = 29 or o.type# = 30)
and o.owner# = u.user#
and (instrb(t.audit$,'S') != 0 or instrb(t.audit$,'A') != 0)
and o.obj# = t.obj#
union all
select u.name, o.name, 'MINING MODEL',
substr(t.audit$, 1, 1) || '/' || substr(t.audit$, 2, 1),
substr(t.audit$, 3, 1) || '/' || substr(t.audit$, 4, 1),
substr(t.audit$, 5, 1) || '/' || substr(t.audit$, 6, 1),
substr(t.audit$, 7, 1) || '/' || substr(t.audit$, 8, 1),
substr(t.audit$, 9, 1) || '/' || substr(t.audit$, 10, 1),
substr(t.audit$, 11, 1) || '/' || substr(t.audit$, 12, 1),
substr(t.audit$, 13, 1) || '/' || substr(t.audit$, 14, 1),
substr(t.audit$, 15, 1) || '/' || substr(t.audit$, 16, 1),
substr(t.audit$, 17, 1) || '/' || substr(t.audit$, 18, 1),
substr(t.audit$, 19, 1) || '/' || substr(t.audit$, 20, 1),
substr(t.audit$, 21, 1) || '/' || substr(t.audit$, 22, 1),
'-/-', /* dummy REF column */
substr(t.audit$, 25, 1) || '/' || substr(t.audit$, 26, 1),
substr(t.audit$, 27, 1) || '/' || substr(t.audit$, 28, 1),
substr(t.audit$, 29, 1) || '/' || substr(t.audit$, 30, 1),
substr(t.audit$, 31, 1) || '/' || substr(t.audit$, 32, 1),
substr(t.audit$, 23, 1) || '/' || substr(t.audit$, 24, 1)
from sys.obj$ o, sys.user$ u, sys.model$ t
where o.type# = 82
and (instrb(t.audit$,'S') != 0 or instrb(t.audit$,'A') != 0)
and o.owner# = u.user#
and o.obj# = t.obj#
union all
select u.name, o.name, 'EDITION',
substr(e.audit$, 1, 1) || '/' || substr(e.audit$, 2, 1),
substr(e.audit$, 3, 1) || '/' || substr(e.audit$, 4, 1),
substr(e.audit$, 5, 1) || '/' || substr(e.audit$, 6, 1),
substr(e.audit$, 7, 1) || '/' || substr(e.audit$, 8, 1),
substr(e.audit$, 9, 1) || '/' || substr(e.audit$, 10, 1),
substr(e.audit$, 11, 1) || '/' || substr(e.audit$, 12, 1),
substr(e.audit$, 13, 1) || '/' || substr(e.audit$, 14, 1),
substr(e.audit$, 15, 1) || '/' || substr(e.audit$, 16, 1),
substr(e.audit$, 17, 1) || '/' || substr(e.audit$, 18, 1),
substr(e.audit$, 19, 1) || '/' || substr(e.audit$, 20, 1),
substr(e.audit$, 21, 1) || '/' || substr(e.audit$, 22, 1),
'-/-', /* dummy REF column */
substr(e.audit$, 25, 1) || '/' || substr(e.audit$, 26, 1),
substr(e.audit$, 27, 1) || '/' || substr(e.audit$, 28, 1),
substr(e.audit$, 29, 1) || '/' || substr(e.audit$, 30, 1),
substr(e.audit$, 31, 1) || '/' || substr(e.audit$, 32, 1),
substr(e.audit$, 23, 1) || '/' || substr(e.audit$, 24, 1)
from sys.obj$ o, sys.user$ u, sys.edition$ e
where o.type# = 57
and o.owner# = u.user#
and (instrb(e.audit$,'S') != 0 or instrb(e.audit$,'A') != 0)
and o.obj# = e.obj#
union all
select u.name, o.name, 'OLAP CUBE DIMENSION',
substr(t.audit$, 1, 1) || '/' || substr(t.audit$, 2, 1),
substr(t.audit$, 3, 1) || '/' || substr(t.audit$, 4, 1),
substr(t.audit$, 5, 1) || '/' || substr(t.audit$, 6, 1),
substr(t.audit$, 7, 1) || '/' || substr(t.audit$, 8, 1),
substr(t.audit$, 9, 1) || '/' || substr(t.audit$, 10, 1),
substr(t.audit$, 11, 1) || '/' || substr(t.audit$, 12, 1),
substr(t.audit$, 13, 1) || '/' || substr(t.audit$, 14, 1),
substr(t.audit$, 15, 1) || '/' || substr(t.audit$, 16, 1),
substr(t.audit$, 17, 1) || '/' || substr(t.audit$, 18, 1),
substr(t.audit$, 19, 1) || '/' || substr(t.audit$, 20, 1),
substr(t.audit$, 21, 1) || '/' || substr(t.audit$, 22, 1),
'-/-', /* dummy REF column */
substr(t.audit$, 25, 1) || '/' || substr(t.audit$, 26, 1),
substr(t.audit$, 27, 1) || '/' || substr(t.audit$, 28, 1),
substr(t.audit$, 29, 1) || '/' || substr(t.audit$, 30, 1),
substr(t.audit$, 31, 1) || '/' || substr(t.audit$, 32, 1),
substr(t.audit$, 23, 1) || '/' || substr(t.audit$, 24, 1)
from sys.obj$ o, sys.user$ u, sys.olap_cube_dimensions$ t
where o.type# = 92
and o.owner# = u.user#
and (instrb(t.audit$,'S') != 0 or instrb(t.audit$,'A') != 0)
and o.obj# = t.obj#
union all
select u.name, o.name, 'OLAP CUBE',
substr(t.audit$, 1, 1) || '/' || substr(t.audit$, 2, 1),
substr(t.audit$, 3, 1) || '/' || substr(t.audit$, 4, 1),
substr(t.audit$, 5, 1) || '/' || substr(t.audit$, 6, 1),
substr(t.audit$, 7, 1) || '/' || substr(t.audit$, 8, 1),
substr(t.audit$, 9, 1) || '/' || substr(t.audit$, 10, 1),
substr(t.audit$, 11, 1) || '/' || substr(t.audit$, 12, 1),
substr(t.audit$, 13, 1) || '/' || substr(t.audit$, 14, 1),
substr(t.audit$, 15, 1) || '/' || substr(t.audit$, 16, 1),
substr(t.audit$, 17, 1) || '/' || substr(t.audit$, 18, 1),
substr(t.audit$, 19, 1) || '/' || substr(t.audit$, 20, 1),
substr(t.audit$, 21, 1) || '/' || substr(t.audit$, 22, 1),
'-/-', /* dummy REF column */
substr(t.audit$, 25, 1) || '/' || substr(t.audit$, 26, 1),
substr(t.audit$, 27, 1) || '/' || substr(t.audit$, 28, 1),
substr(t.audit$, 29, 1) || '/' || substr(t.audit$, 30, 1),
substr(t.audit$, 31, 1) || '/' || substr(t.audit$, 32, 1),
substr(t.audit$, 23, 1) || '/' || substr(t.audit$, 24, 1)
from sys.obj$ o, sys.user$ u, sys.olap_cubes$ t
where o.type# = 93
and o.owner# = u.user#
and (instrb(t.audit$,'S') != 0 or instrb(t.audit$,'A') != 0)
and o.obj# = t.obj#
union all
select u.name, o.name, 'OLAP MEASURE FOLDER',
substr(t.audit$, 1, 1) || '/' || substr(t.audit$, 2, 1),
substr(t.audit$, 3, 1) || '/' || substr(t.audit$, 4, 1),
substr(t.audit$, 5, 1) || '/' || substr(t.audit$, 6, 1),
substr(t.audit$, 7, 1) || '/' || substr(t.audit$, 8, 1),
substr(t.audit$, 9, 1) || '/' || substr(t.audit$, 10, 1),
substr(t.audit$, 11, 1) || '/' || substr(t.audit$, 12, 1),
substr(t.audit$, 13, 1) || '/' || substr(t.audit$, 14, 1),
substr(t.audit$, 15, 1) || '/' || substr(t.audit$, 16, 1),
substr(t.audit$, 17, 1) || '/' || substr(t.audit$, 18, 1),
substr(t.audit$, 19, 1) || '/' || substr(t.audit$, 20, 1),
substr(t.audit$, 21, 1) || '/' || substr(t.audit$, 22, 1),
'-/-', /* dummy REF column */
substr(t.audit$, 25, 1) || '/' || substr(t.audit$, 26, 1),
substr(t.audit$, 27, 1) || '/' || substr(t.audit$, 28, 1),
substr(t.audit$, 29, 1) || '/' || substr(t.audit$, 30, 1),
substr(t.audit$, 31, 1) || '/' || substr(t.audit$, 32, 1),
substr(t.audit$, 23, 1) || '/' || substr(t.audit$, 24, 1)
from sys.obj$ o, sys.user$ u, sys.olap_measure_folders$ t
where o.type# = 94
and o.owner# = u.user#
and (instrb(t.audit$,'S') != 0 or instrb(t.audit$,'A') != 0)
and o.obj# = t.obj#
union all
select u.name, o.name, 'OLAP CUBE BUILD PROCESS',
substr(t.audit$, 1, 1) || '/' || substr(t.audit$, 2, 1),
substr(t.audit$, 3, 1) || '/' || substr(t.audit$, 4, 1),
substr(t.audit$, 5, 1) || '/' || substr(t.audit$, 6, 1),
substr(t.audit$, 7, 1) || '/' || substr(t.audit$, 8, 1),
substr(t.audit$, 9, 1) || '/' || substr(t.audit$, 10, 1),
substr(t.audit$, 11, 1) || '/' || substr(t.audit$, 12, 1),
substr(t.audit$, 13, 1) || '/' || substr(t.audit$, 14, 1),
substr(t.audit$, 15, 1) || '/' || substr(t.audit$, 16, 1),
substr(t.audit$, 17, 1) || '/' || substr(t.audit$, 18, 1),
substr(t.audit$, 19, 1) || '/' || substr(t.audit$, 20, 1),
substr(t.audit$, 21, 1) || '/' || substr(t.audit$, 22, 1),
'-/-', /* dummy REF column */
substr(t.audit$, 25, 1) || '/' || substr(t.audit$, 26, 1),
substr(t.audit$, 27, 1) || '/' || substr(t.audit$, 28, 1),
substr(t.audit$, 29, 1) || '/' || substr(t.audit$, 30, 1),
substr(t.audit$, 31, 1) || '/' || substr(t.audit$, 32, 1),
substr(t.audit$, 23, 1) || '/' || substr(t.audit$, 24, 1)
from sys.obj$ o, sys.user$ u, sys.olap_cube_build_processes$ t
where o.type# = 95
and o.owner# = u.user#
and (instrb(t.audit$,'S') != 0 or instrb(t.audit$,'A') != 0)
and o.obj# = t.obj#

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