Sqls doing full table scan - Oracle Database Script. 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');
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');