溫馨提示×
您好，登錄后才能下訂單哦！
點擊 登錄注冊 即表示同意《億速云用戶服務條款》
您好，登錄后才能下訂單哦！
select s.sid, s.serial#, 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 / 100 as 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 = s.serial# and s.username is not null and s.status = 'ACTIVE' group by s.sid, s.serial#, 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 * FROM (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 <= 50;
免責聲明：本站發布的內容（圖片、視頻和文字）以原創、轉載和分享為主，文章觀點不代表本網站立場，如果涉及侵權請聯系站長郵箱：is@yisu.com進行舉報，并提供相關證據，一經查實，將立刻刪除涉嫌侵權內容。
