执行前修改p.OBJECT_OWNER,注意都是大写字母
select table_name, num_rows
from user_tables
where table_name not in (select distinct table_name from user_indexes)
and table_name not like '%_BAK'
and table_name not like '%_BK'
and num_rows > 1000
and table_name in (SELECT distinct p.OBJECT_NAME
FROM v$sql_plan p
WHERE p.operation = 'TABLE ACCESS'
and p.OBJECT_OWNER = 'HR_GD'
AND p.options = 'FULL')
order by num_rows desc