OraFAQ Forum: Performance Tuning

Home » RDBMS Server » Performance Tuning » ASH Report (Oracle 11G,Linux 5)

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

ASH Report [message #566242]

Wed, 12 September 2012 00:00

saagar
Messages: 79
Registered: December 2007

Member

Hi

In ASH report

there is a section that goes like this

SQL ID	         Planhashed   Sampled # of Executions        % Activity	Event	% Event         Top Row Source	        
fdy93qpr	1227                   1567	               7.58	direct path read 3.65	TABLE ACCESS - FULL

does it suggest that this SQL has been executed for 1567 times is this correct ...

yes this suggest that there is full table scan right...

CHeers

Report message to a moderator

Re: ASH Report [message #566255 is a reply to message #566242]

Wed, 12 September 2012 01:19

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

Senior Member
Account Moderator

Yes, yes.

Regards
Michel

Report message to a moderator

Re: ASH Report [message #566267 is a reply to message #566255]

Wed, 12 September 2012 01:59

saagar
Messages: 79
Registered: December 2007

Member

Hi Michael

thanks !!!

can you please let me know how is there any documentation to study in-depth analysis AWR,ASH , ADDM reoprt

CHeers

Report message to a moderator

Re: ASH Report [message #566269 is a reply to message #566267]

Wed, 12 September 2012 02:10

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

Senior Member
Account Moderator

I think If you go to OTN, you will find several papers.

Regards
Michel

[Edit: typo]

[Updated on: Wed, 12 September 2012 12:34]

Report message to a moderator

Re: ASH Report [message #566319 is a reply to message #566269]

Wed, 12 September 2012 12:18

saagar
Messages: 79
Registered: December 2007

Member

Hi Micheal
Could you please let me know any link
there are lot many documents

thanking you once again

Report message to a moderator

Re: ASH Report [message #566321 is a reply to message #566319]

Wed, 12 September 2012 12:30

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

since when are we your Research Assistants?

Report message to a moderator

Re: ASH Report [message #566334 is a reply to message #566321]

Wed, 12 September 2012 21:14

saagar
Messages: 79
Registered: December 2007

Member

Hi Blackswan

i am sorry if you have misunderstood...
i was just asking if any exact document page or link on that ...thats all
didnt mean that

CHeers

Report message to a moderator

Re: ASH Report [message #566345 is a reply to message #566334]

Wed, 12 September 2012 23:50

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

Senior Member
Account Moderator

And we ask you why we should do the research for you.
Why don't you try to find byyourself with the link I gave you?
If you can't do this simple search, it is useless to go further with subject like ASH report that requires higher research skills to be useful.

Regards
Michel

Report message to a moderator

Previous Topic:	tuning stats command
Next Topic:	Help needed to tune the SQL (merged 2)

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Feb 21 04:10:37 CST 2025