VIEW: SYS.USER_TAB_MODIFICATIONS

Source

View Text - Preformatted

select 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
where o.owner# = userenv('SCHEMAID') and o.obj# = m.obj# and o.obj# = t.obj#
union all
  select 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
  where o.owner# = userenv('SCHEMAID') and o.obj# = m.obj# and o.type#=19
union all
select 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
where o.owner# = userenv('SCHEMAID') and o.obj# = m.obj# and
      o.obj# = tsp.obj# and o2.obj# = tsp.pobj#

View Text - HTML Formatted

SELECT 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 WHERE O.OWNER# = USERENV('SCHEMAID')
AND O.OBJ# = M.OBJ#
AND O.OBJ# = T.OBJ# UNION ALL SELECT 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
WHERE O.OWNER# = USERENV('SCHEMAID')
AND O.OBJ# = M.OBJ#
AND O.TYPE#=19 UNION ALL SELECT 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 WHERE O.OWNER# = USERENV('SCHEMAID')
AND O.OBJ# = M.OBJ# AND O.OBJ# = TSP.OBJ#
AND O2.OBJ# = TSP.POBJ#