OraFAQ Forum: Server Administration » How to run ADDM report for the particular SQL stmt

Home » RDBMS Server » Server Administration » How to run ADDM report for the particular SQL stmt (10g, 10.2.0.4, OEL-4.5)

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

How to run ADDM report for the particular SQL stmt [message #582738]

Mon, 22 April 2013 06:19

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

Report message to a moderator

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

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

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

Report message to a moderator

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

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

Report message to a moderator

Previous Topic:	ORA-00554 initialization of internal recovery manager package failed
Next Topic:	about oracle database 9i

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Jan 27 12:08:39 CST 2025