Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to query AWR views/tables?

926936Jun 7 2012 — edited Jun 7 2012

Hi,

AWR reports statistics related to SQLs used in DB/application.

I have a requirement to find out the location of those SQLs. Can anyone please help me how can I do that? Is there any internal table/view I can query to find the location?

Regards,
Ashok

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 5 2012

Added on Jun 7 2012

#general-database-discussions

8 comments

4,634 views