-------------------------------------------------------
--  what : hinsrt.sql 
--  when : 12 Apr 2006
--   why : identifies INSERT statements by order of executions
--         descending
-- where :  
--   how : 
--   who : David Clement, SUM Global Technology
--   fix :
-----------------------------------------------------------

column sql format a60
column execs format 999,999,999,999

select substr (sql_text, 1, 60) sql, sum (executions) execs
from v$sql
where command_type = 2
group by substr (sql_text, 1, 60)
order by sum (executions) desc
/