Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RDA - Top SQL report

RDA - Top SQL report

From: Srikanth Kalluri <SKalluri_at_osius.com>
Date: Wed, 1 Mar 2006 15:10:52 -0800
Message-ID: <8E8BAC73BE915949804C4E9A27CB1DDFA01D50@ex2.osius.com>


Hi,  

The question is regarding (Remote Diagnostics Assistant; Metalink Note: 314422.1) Oracle Support provides to troubleshoot performance issues in a database {RDA} and the calculation of the "Top SQL Report"  

More specifically, I am curious how the following ratios are deemed "Expected Respose Time (in Seconds)"  

From v$sqlarea:
{ (disk_reads/executions)/50 }
{ (buffer_gets/executions)/500 }
 

Also, what is the significance of the numbers 50 and 500 respectively?  

Queries used in the report:  

select
 sql_text,
 executions,
 disk_reads / decode(executions,0,1, executions) / 50 from
 v$sqlarea
where
 disk_reads / decode(executions,0,1, executions) / 50 > 100 order by executions desc;

select
 sql_text,
 executions,
 buffer_gets / decode(executions,0,1, executions) / 500 from
 v$sqlarea
where
 buffer_gets/ decode(executions,0,1, executions) / 500 > 100 order by executions desc;  

Thanks,
Sri    

--
http://www.freelists.org/webpage/oracle-l
Received on Wed Mar 01 2006 - 17:10:52 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US