Select SQL_text, sum(OPTIMAL_EXECUTIONS) OPTIMUM_EXECS, sum(ONEPASS_EXECUTIONS) ONE_PASS_EXECS, sum(MULTIPASSES_EXECUTIONS) MULTI_PASS_EXECS from v$sql s, v$sql_workarea w where s.sql_text like ‘select * from t order by 1%’ and s.sql_id=w.sql_id group by sql_text;

– LOOK AT PGA ADVISOR TO FIND OUT IF THE CURRENT SIZE OF PFA IS APPROPRIATE