Queries causing high physical read - Oracle Database Script. SELECT SCHEMA, sql_text, disk_reads, round(cpu, 2) FROM (SELECT s.parsing_schema_name SCHEMA, t.sql_id, t.sql_text, 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 = 'SCOTT' ORDER BY disk_reads DESC) WHERE rownum <= 5;
SELECT SCHEMA, sql_text, disk_reads, round(cpu, 2) FROM (SELECT s.parsing_schema_name SCHEMA, t.sql_id, t.sql_text, 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 = 'SCOTT' ORDER BY disk_reads DESC) WHERE rownum <= 5;