SELECT a.top_sql_text fROM v$sql_history a ,V$VMS b where a.trx_id= b.trx_id order by n_logic_read;
SELECT a.top_sql_text FROM v$sql_history a ,V$VMS b where a.trx_id= b.trx_id order by n_phy_read;
SELECT a.top_sql_text FROM v$sql_history a ,V$VMS b where a.trx_id= b.trx_id order by VUSED;
SELECT a.top_sql_text FROM v$sql_history a ,V$VMS b where a.trx_id= b.trx_id order by STKFRM_DEPTH;