DBA Hub

📋Steps in this guide1/1

Sqls doing full table scan

select sql_id,object_owner,object_name from V$SQL_PLAN where operation='TABLE ACCESS' and options='FULL' and object_owner not in ('SYS','SYSTEM','DBSNMP');

oracle configurationintermediate
by OracleDba
12 views
1

Sqls doing full table scan

Code/Command (click line numbers to comment):

1
2
3
4
select sql_id,object_owner,object_name from V$SQL_PLAN where
operation='TABLE ACCESS' and
options='FULL' and
object_owner not in ('SYS','SYSTEM','DBSNMP');

Comments (0)

Please to add comments

No comments yet. Be the first to comment!