VIEW: SYS.DBA_SR_STLOG_STATS

Source

View Text - Preformatted

select u1.name owner,
          o1.name table_name,
          o2.name staging_log_name,
          sts.num_inserts,
          sts.num_deletes,
          sts.num_updates,
          decode(sts.psl_mode,
                 7, 'TRUSTED',
	         6, 'DELETE_TRUSTED and UPDATE_TRUSTED',
	         5, 'UPDATE_TRUSTED and INSERT_TRUSTED',
	         4, 'UPDATE_TRUSTED',
                 3, 'INSERT_TRUSTED and DELETE_TRUSTED',
                 2, 'DELETE_TRUSTED',
                 1, 'INSERT_TRUSTED',
                 0, 'ENFORCED') as psl_mode
  from  sys.obj$ o1, sys.user$ u1,
  sys.obj$ o2, sys.syncref$_table_info t1,
  sys.syncref$_stlog_stats sts
  where
      t1.table_obj# = o1.obj# and o1.owner# = u1.user#  and
      t1.staging_log_obj# = o2.obj# and
      t1.table_obj# = sts.table_obj#

View Text - HTML Formatted

SELECT U1.NAME OWNER
, O1.NAME TABLE_NAME
, O2.NAME STAGING_LOG_NAME
, STS.NUM_INSERTS
, STS.NUM_DELETES
, STS.NUM_UPDATES
, DECODE(STS.PSL_MODE
, 7
, 'TRUSTED'
, 6
, 'DELETE_TRUSTED
AND UPDATE_TRUSTED'
, 5
, 'UPDATE_TRUSTED
AND INSERT_TRUSTED'
, 4
, 'UPDATE_TRUSTED'
, 3
, 'INSERT_TRUSTED
AND DELETE_TRUSTED'
, 2
, 'DELETE_TRUSTED'
, 1
, 'INSERT_TRUSTED'
, 0
, 'ENFORCED') AS PSL_MODE
FROM SYS.OBJ$ O1
, SYS.USER$ U1
, SYS.OBJ$ O2
, SYS.SYNCREF$_TABLE_INFO T1
, SYS.SYNCREF$_STLOG_STATS STS WHERE T1.TABLE_OBJ# = O1.OBJ#
AND O1.OWNER# = U1.USER# AND T1.STAGING_LOG_OBJ# = O2.OBJ# AND T1.TABLE_OBJ# = STS.TABLE_OBJ#