Oracle中SQL记录中~~

查询oracle正在运行效率最慢的前十条SQL：

SELECT *  FROM (SELECT parsing_user_id,               executions,               sorts,               command_type,               disk_reads,               sql_text          FROM v$sqlarea         ORDER BY disk_reads DESC) WHERE rownum < 10