Home » RDBMS Server » Performance Tuning » diskreads/executions
diskreads/executions [message #326615] Thu, 12 June 2008 02:12 Go to next message
bm50793
Messages: 7
Registered: June 2008
Junior Member
Hi ,


select b.username username, a.disk_reads reads,a.executions exec, a.disk_reads /decode
(a.executions, 0, 1,a.executions) rds_exec_ratio,a.sql_text Statement
from V$sqlarea a, dba_users b
where a.parsing_user_id = b.user_id
and a.disk_reads > 100000
order by a.disk_reads desc;

can anyone please tell me the significance of rds_exec_ratio (indicated in red in the above query) also where can i find the description for the columns of v$SQLAREA

many thanks in advance......
Re: diskreads/executions [message #326627 is a reply to message #326615] Thu, 12 June 2008 02:22 Go to previous messageGo to next message
Michel Cadot
Messages: 64145
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Quote:
rds_exec_ratio

Number of reads per query execution

Quote:
can i find the description for the columns of v$SQLAREA

Reference Manual

Read OraFAQ Forum Guide, especially "How to format your post?" section.
Make sure that lines of code do not exceed 80 characters when you format.
Indent the code (See SQL Formatter).
Use the "Preview Message" button to verify.
Also always post your Oracle version (4 decimals).

Regards
Michel
Re: diskreads/executions [message #326656 is a reply to message #326627] Thu, 12 June 2008 03:18 Go to previous message
bm50793
Messages: 7
Registered: June 2008
Junior Member
hi Michel,

apologies for the inconvenience caused,will surely follow the forum guidelines .

thanks for the suggestions Smile
Previous Topic: explain plan
Next Topic: sessions were hung for long time
Goto Forum:
  


Current Time: Fri Dec 09 11:37:39 CST 2016

Total time taken to generate the page: 0.15518 seconds