Current top resource consuming SQLs

SELECT b.parsing_schema_name,a.sql_id,a.sql_fulltext,a.buffer_gets, a.disk_reads, b.sorts,   
a.cpu_time/1000000 cpu, a.rows_processed, a.elapsed_time
FROM v$sqlstats a, v$sql b
WHERE rownum <= 5
AND A.SQL_ID=B.SQL_ID
ORDER BY CPU DESC

====================================================

SELECT schema, SQL_FULLTEXT, disk_reads, round(cpu,2) FROM
(SELECT s.parsing_schema_name schema, t.sql_id, t.sql_FULLtext, t.disk_reads,
t.sorts, t.cpu_time/1000000 cpu, t.rows_processed, t.elapsed_time
FROM v$sqlstats t join v$sql s on(t.sql_id = s.sql_id)
WHERE parsing_schema_name = 'ATT'
ORDER BY disk_reads DESC)

WHERE rownum <= 5;