Wednesday, June 28, 2017

High load SQL in Oracle

select a.sql_id, a.ratio, a.executions
from
(
  select sql_id, buffer_gets / executions ratio, executions
  from v$sql
  where executions > 10
  order by 2 desc
) a
where rownum <= 10
/
select * from v$sql where sql_id='xxxxxxxx'

No comments:

Post a Comment