select * from ( select crs.ACTUAL_START_DATE,crs.ACTUAL_COMPLETION_DATE , floor(to_number(crs.ACTUAL_COMPLETION_DATE- crs.ACTUAL_START_DATE )*24*60) as spanMinutes ,crs.PROGRAM from FND_CONC_REQ_SUMMARY_V crs ) a where a.spanMinutes>5[@more@]

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博客

怎么查看ebs里面的请求运行时间

最新文章