--查询v$librarycache:
select sum(pins) "Executions",
sum(pinhits) "Hits",
((sum(pinhits) / sum(pins)) * 100) "PinHitRatio",
sum(reloads) "Misses",
((sum(pins) / (sum(pins) + sum(reloads))) * 100) "RelHitRatio"
from v$librarycache;
--查询 v$sql_bind_capture，看看 average binds 是否大于15 (issue):
select sql_id, count(*) bind_count
from v$sql_bind_capture
where child_number = 0
group by sql_id
having count(*) > 20
order by count(*);
--查找有问题的SQL并修复它：
select sql_text, users_executing, executions, users_opening, buffer_gets
from v$sqlarea
where sql_id = 'c0agatqzq2jzr'
order by buffer_gets;[@more@]另：
通过以下sql，可查找最耗时sql,想办法优化：
Select * From v$sqlarea Order By cpu_time Desc
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/11419868/viewspace-1055627/ ，如需转载，请注明出处，否则将追究法律责任。
请登录后发表评论
登录
全部评论
