Top 10 worst sql statements in the sga query.. works in 8 but not 7...

[bmycroft]

Hi guys,
I have a query that returns the top 10 sql statements ordered by disk reads

SELECT sql_text,
executions,
buffer_gets,
disk_reads,
parse_calls,
rows_processed
FROM (
SELECT sql_text,
executions,
buffer_gets,
disk_reads,
parse_calls,
rows_processed
FROM v$sql
ORDER BY disk_reads DESC
)
WHERE ROWNUM < 11
/

Works fine in 8, but not in 7. The reason being that the ORDER BY in the inline-view is not allowed until 8. Any ideas how I can modify this to work with 7 (without resorting to PLSQL!).

-Bob