Home » RDBMS Server » Performance Tuning » ASH Report (Oracle 11G,Linux 5)
icon9.gif  ASH Report [message #566242] Wed, 12 September 2012 00:00 Go to next message
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

Re: ASH Report [message #566255 is a reply to message #566242] Wed, 12 September 2012 01:19 Go to previous messageGo to next message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Yes, yes.

Regards
Michel
Re: ASH Report [message #566267 is a reply to message #566255] Wed, 12 September 2012 01:59 Go to previous messageGo to next message
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
Re: ASH Report [message #566269 is a reply to message #566267] Wed, 12 September 2012 02:10 Go to previous messageGo to next message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
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 Go to previous messageGo to next message
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
Re: ASH Report [message #566321 is a reply to message #566319] Wed, 12 September 2012 12:30 Go to previous messageGo to next message
BlackSwan
Messages: 22558
Registered: January 2009
Senior Member
since when are we your Research Assistants?
Re: ASH Report [message #566334 is a reply to message #566321] Wed, 12 September 2012 21:14 Go to previous messageGo to next message
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
Re: ASH Report [message #566345 is a reply to message #566334] Wed, 12 September 2012 23:50 Go to previous message
Michel Cadot
Messages: 58645
Registered: March 2007
Location: Nanterre, France, http://...
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
Previous Topic: tuning stats command
Next Topic: Help needed to tune the SQL (merged 2)
Goto Forum:
  


Current Time: Sat Aug 02 04:44:25 CDT 2014

Total time taken to generate the page: 0.11470 seconds