获得全表扫描的对象
SQL> select distinct object_name,object_owner from v$sql_plan p
2 where p.operation='TABLE ACCESS' and p.options='FULL'
3 and object_owner = 'TEST';
OBJECT_NAME OBJECT_OWNER
------------------------------ ------------------------------
WORKER TEST
获得全表扫描的对象
最新推荐文章于 2024-07-17 07:19:03 发布