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 find SQL id and Execution plan for old query

Deepak PushkarnaJan 30 2014 — edited Jan 30 2014

Hi Guys,

I want to compare the current execution plan of a query with the 3 days back execution plan.

Can anyone guide me how can I fetch the SQL id and old execution plan from Oracle.

I am using Oracle 11.2.0.3 version of database, I have also checked AWR report, but the query is not there.

The query runs around same time daily.

Thanks & Regards,

Deepak

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 27 2014

Added on Jan 30 2014

#general-database-discussions

6 comments

10,129 views