2: 占CPU资源top5的sql查询
select *
from (select * from v$sql order by cpu_time desc) q
where rownum <= 5
3:磁盘IO前10的sql查询
select *
from (select round((disk_reads/decode(executions,0,-99999999,executions)))
disk_reads_per_exec,v$sql.*
from v$sql
order by disk_reads_per_exec desc) q
where rownum <= 10
4:其他的
--查看进程CPU占用情况的
Linux
ps auxw --sort=%cpu
--查询IO
SELECT si.physical_reads,se.osuser, se.sid,se.serial#,pr.SPID,se.username,se.status,se.terminal,se.program,se.MODULE,se.sql_address,st.event,st.p1text,si.block_changes
,se.*
FROM v$session se, v$session_wait st,v$sess_io si,v$process pr
WHERE st.sid=se.sid AND st.sid=si.sid AND se.PADDR=pr.ADDR AND se.sid>6 AND st.wait_time=0 AND st.event NOT LIKE '%SQL%' ORDER BY physical_reads DESC
--查询等待
Select s.osuser, s.username,s.program,s.status,se.event,se.total_waits,se.total_timeouts,se.time_waited,se.average_wait
,s.*
from v$session s, v$session_event se
Where s.sid=se.sid And se.event not like 'SQl*Net%'And s.status ='ACTIVE'And s.username is not null
order by total_waits desc
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8109090/viewspace-1057537/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/8109090/viewspace-1057537/