Bad Sql

Following SQL will help you to find bad SQL Statements in Oracle.

SELECT disk_reads, executions,
disk_reads/DECODE(executions, 0, 1, executions) "READS_PER_EXEC",
sql_text
FROM v$sqlarea
WHERE executions > 10
ORDER BY executions desc