Oracle 检查数据库有哪些表频繁进行全表扫描

最新推荐文章于 2024-07-02 12:40:00 发布

weixin_33769207

最新推荐文章于 2024-07-02 12:40:00 发布

阅读量529

点赞数

文章标签：数据库

原文链接：http://www.cnblogs.com/fubinhnust/p/9925918.html

版权

select a.object_name,
a.sql_id,
b.sql_text,
max(b.executions) executions,
max(b.last_active_time) last_active_time,
b.first_load_time
from v$sql_plan a, v$sql b
where a.sql_id = b.sql_id
and a.object_type = 'TABLE'
and a.options = 'FULL'
and a.object_name not like '%$%'
group by a.object_name, a.sql_id, b.sql_text, b.first_load_time;

转载于:https://www.cnblogs.com/fubinhnust/p/9925918.html