break on address
column address noprint
select a.address, executions, b.sql_text
from v$sqlarea a, v$sqltext b
where parse_calls !=1
and parse_calls = executions
and a.address = b.address
order by executions, a.address, b.piece;
break on address
column address noprint
select a.address, executions, b.sql_text
from v$sqlarea a, v$sqltext b
where parse_calls !=1
and parse_calls = executions
and a.address = b.address
order by executions, a.address, b.piece;