Highcost SQL
Select s.sid, s.serializations, s.username, s.sql_id, m.physical_reads, m.logical_reads, m.hard_parses, m.physical_read_pct, trunc (m.logical_read_pct) as logical_read_pct, m.cpu / 100as CPU from v$sessmetric m V$session s where (m.physical_reads > 100 or m.cpu > 100 or m.logical_reads > 100) and m.session_id = s.sid and m.session_serial_num = 'ACTIVE' group by s.sid, s.serializations, s.username, m.physical_reads, m.logical_reads, m.hard_parses M.physical_read_pct, m.logical_read_pct, cpu, s.sql_id order by m.physical_reads, m.cpu, m.logical_reads
= =
SELECT * FROM (SELECT u.name owner, o.name table_name, NULL partition_name, NULL subpartition_name, m.inserts) M.updates, m.deletes, m.timestamp, decode (bitand (m.flags, 1), 1, 'YES',' NO') truncated 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#) WHERE owner NOT LIKE'% SYS%' AND owner NOT LIKE 'XDB' UNION ALL SELECT * FROM (SELECT u.name owner O.name table_name, NULL partition_name, NULL subpartition_name, m.inserts, m.updates, m.deletes M.timestamp, decode (bitand (m.flags, 1), 1, 'YES',' NO') truncated, m.drop_segments FROM sys.mon_mods$ 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$ 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$ 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#) WHERE owner NOT LIKE'% SYS%' AND owner NOT LIKE'% XDB%') ORDER BY inserts DESC) WHERE rownum
