select * from ( select sql_id, elapsed_time, executions, sql_text from v$sql ORDER BY elapsed_time desc ) where rownum < 11;