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;
成都創(chuàng)新互聯(lián)公司是專業(yè)的江干網(wǎng)站建設(shè)公司，江干接單;提供成都做網(wǎng)站、網(wǎng)站設(shè)計(jì),網(wǎng)頁(yè)設(shè)計(jì),網(wǎng)站設(shè)計(jì),建網(wǎng)站,PHP網(wǎng)站建設(shè)等專業(yè)做網(wǎng)站服務(wù);采用PHP框架,可快速的進(jìn)行江干網(wǎng)站開發(fā)網(wǎng)頁(yè)制作和功能擴(kuò)展;專業(yè)做搜索引擎喜愛的網(wǎng)站,專業(yè)的做網(wǎng)站團(tuán)隊(duì),希望更多企業(yè)前來(lái)合作!
==
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;
重慶分公司
重慶分公司
