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');