Thursday, August 2, 2012

Script to identify queries having full table scan

SELECT   sql_text
    FROM   v$sql
   WHERE   (address, hash_value, child_number) IN
                 (SELECT   address, hash_value, child_number
                    FROM   v$sql_plan
                   WHERE   operation = 'TABLE ACCESS' AND options = 'FULL')
ORDER BY   sql_text

No comments:

Post a Comment