REM Filename : litersql.sql

REM Author : Craig Richards

REM Created : 06-March-2009

REM Version : 1.0

REM Modifications :

REM

REM Description : Identify statements that could benefit converting to using bind variables

SET VERIFY OFF

SELECT SUBSTR(sql_text,1,60) "SQL", COUNT(*),SUM(executions) "TOTAL EXECUTIONS"

FROM v$sqlarea

WHERE executions < 5

GROUP BY SUBSTR(sql_text,1,60)

HAVING COUNT(*) > 20

ORDER BY 2;

REM End of Script