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: 334
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: 57607
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: 334
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: Thu Apr 17 17:56:35 CDT 2014

Total time taken to generate the page: 0.13078 seconds