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

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;