Home » RDBMS Server » Server Administration » How to run ADDM report for the particular SQL stmt (10g, 10.2.0.4, OEL-4.5)
How to run ADDM report for the particular SQL stmt [message #582738] Mon, 22 April 2013 06:19 Go to next message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Dear All,

We are not using enterprise manager. Now, i want to generate ADDM report for the particular SQL stmt. How can i do that?
Please let me know the steps of doing it.

Regards,
Ishika
Re: How to run ADDM report for the particular SQL stmt [message #582741 is a reply to message #582738] Mon, 22 April 2013 06:27 Go to previous messageGo to next message
Michel Cadot
Messages: 59291
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
You cannot.
ADDM report is not one SQL oriented.
But you can get an AWR report for a SQL ID.

Regards
Michel
Re: How to run ADDM report for the particular SQL stmt [message #582747 is a reply to message #582741] Mon, 22 April 2013 06:41 Go to previous message
ishika_20
Messages: 339
Registered: December 2006
Location: delhi
Senior Member
Thank you very much Michel.

I was having confusion. Now, its got clear. We can get SQl id's from AWR report.

Regards,
Ishika
Previous Topic: ORA-00554 initialization of internal recovery manager package failed
Next Topic: about oracle database 9i
Goto Forum:
  


Current Time: Wed Oct 01 17:23:59 CDT 2014

Total time taken to generate the page: 0.07133 seconds