VIEW: SYS.USER_OBJECT_USAGE

Source

View Text - Preformatted

select io.name, t.name,
       decode(bitand(i.flags, 65536), 0, 'NO', 'YES'),
       decode(bitand(ou.flags, 1), 0, 'NO', 'YES'),
       ou.start_monitoring,
       ou.end_monitoring
from sys.obj$ io, sys.obj$ t, sys.ind$ i, sys.object_usage ou
where io.owner# = userenv('SCHEMAID')
  and i.obj# = ou.obj#
  and io.obj# = ou.obj#
  and t.obj# = i.bo#

View Text - HTML Formatted

SELECT IO.NAME
, T.NAME
, DECODE(BITAND(I.FLAGS
, 65536)
, 0
, 'NO'
, 'YES')
, DECODE(BITAND(OU.FLAGS
, 1)
, 0
, 'NO'
, 'YES')
, OU.START_MONITORING
, OU.END_MONITORING FROM SYS.OBJ$ IO
, SYS.OBJ$ T
, SYS.IND$ I
, SYS.OBJECT_USAGE OU WHERE IO.OWNER# = USERENV('SCHEMAID')
AND I.OBJ# = OU.OBJ#
AND IO.OBJ# = OU.OBJ#
AND T.OBJ# = I.BO#