Cheeky Cockatoo

Life Advice and Stories, Travel, Oracle Tech, Good Food and More

unshared_sql.sql

Download Script

SELECT substr(sql_text,1,40) "SQL", 
       count(*) , 
       sum(executions) "TotExecs"
FROM v$sqlarea
WHERE executions < 100
GROUP BY substr(sql_text,1,40)
HAVING count(*) > 30
ORDER BY 2;