VIEW: SYS.DBA_TAB_MODIFICATIONS

Source

View Text - Preformatted

select u.name, o.name, null, null,
       m.inserts, m.updates, m.deletes, m.timestamp,
       decode(bitand(m.flags,1),1,'YES','NO'),
       m.drop_segments
from sys.mon_mods_all$ m, sys.obj$ o, sys.tab$ t, sys.user$ u
where o.obj# = m.obj# and o.obj# = t.obj# and o.owner# = u.user#
union all
select u.name, o.name, o.subname, null,
       m.inserts, m.updates, m.deletes, m.timestamp,
       decode(bitand(m.flags,1),1,'YES','NO'),
       m.drop_segments
from sys.mon_mods_all$ m, sys.obj$ o, sys.user$ u
where o.owner# = u.user# and o.obj# = m.obj# and o.type#=19
union all
select u.name, o.name, o2.subname, o.subname,
       m.inserts, m.updates, m.deletes, m.timestamp,
       decode(bitand(m.flags,1),1,'YES','NO'),
       m.drop_segments
from sys.mon_mods_all$ m, sys.obj$ o, sys.tabsubpart$ tsp, sys.obj$ o2,
     sys.user$ u
where o.obj# = m.obj# and o.owner# = u.user# and
      o.obj# = tsp.obj# and o2.obj# = tsp.pobj#

View Text - HTML Formatted

SELECT U.NAME
, O.NAME
, NULL
, NULL
, M.INSERTS
, M.UPDATES
, M.DELETES
, M.TIMESTAMP
, DECODE(BITAND(M.FLAGS
, 1)
, 1
, 'YES'
, 'NO')
, M.DROP_SEGMENTS FROM SYS.MON_MODS_ALL$ M
, SYS.OBJ$ O
, SYS.TAB$ T
, SYS.USER$ U WHERE O.OBJ# = M.OBJ#
AND O.OBJ# = T.OBJ#
AND O.OWNER# = U.USER# UNION ALL SELECT U.NAME
, O.NAME
, O.SUBNAME
, NULL
, M.INSERTS
, M.UPDATES
, M.DELETES
, M.TIMESTAMP
, DECODE(BITAND(M.FLAGS
, 1)
, 1
, 'YES'
, 'NO')
, M.DROP_SEGMENTS FROM SYS.MON_MODS_ALL$ M
, SYS.OBJ$ O
, SYS.USER$ U WHERE O.OWNER# = U.USER#
AND O.OBJ# = M.OBJ#
AND O.TYPE#=19 UNION ALL SELECT U.NAME
, O.NAME
, O2.SUBNAME
, O.SUBNAME
, M.INSERTS
, M.UPDATES
, M.DELETES
, M.TIMESTAMP
, DECODE(BITAND(M.FLAGS
, 1)
, 1
, 'YES'
, 'NO')
, M.DROP_SEGMENTS FROM SYS.MON_MODS_ALL$ M
, SYS.OBJ$ O
, SYS.TABSUBPART$ TSP
, SYS.OBJ$ O2
, SYS.USER$ U WHERE O.OBJ# = M.OBJ#
AND O.OWNER# = U.USER# AND O.OBJ# = TSP.OBJ#
AND O2.OBJ# = TSP.POBJ#