OraFAQ Forum: Performance Tuning » diskreads/executions

Home » RDBMS Server » Performance Tuning » diskreads/executions

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

diskreads/executions [message #326615]

Thu, 12 June 2008 02:12

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......

Report message to a moderator

Re: diskreads/executions [message #326627 is a reply to message #326615]

Thu, 12 June 2008 02:22

Michel Cadot
Messages: 68729
Registered: March 2007
Location: Saint-Maur, France, https...

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

Report message to a moderator

Re: diskreads/executions [message #326656 is a reply to message #326627]

Thu, 12 June 2008 03:18

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

Report message to a moderator

Previous Topic:	explain plan
Next Topic:	sessions were hung for long time

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Jan 09 20:19:16 CST 2025