Script – Top SQL (Physical Reads)

This script will list the top 5 SQL statements sorted by the most number of physical reads set serverout on size 1000000 set feedback off declare top5 number; text1 varchar2(4000); x number; len1 number; Cursor c1 is select disk_reads,substr(sql_text,1,4000) from v$sqlarea order by disk_reads desc; begin dbms_output.put_line(‘Reads’||’ ‘||’ Text’); dbms_output.put_line (‘—–‘||’ ‘||’—————————————————-‘); dbms_output.put_line(‘ ‘); open […]

Add A Knowledge Base Question !

You will receive an email when your question will be answered.

+ = Verify Human or Spambot ?