SQL Performance (MOSC)

MOSC Banner

how to retrieve past SQL execution plan

edited May 28, 2014 9:21AM in SQL Performance (MOSC) 3 commentsAnswered ✓
Hi,

I have a DB running 11.2.0.2 RAC DB in HPUX, recently I found the execution plan generated from one of the SQL is not stable, the plan that i generate now may not be the same as it was ran in scheduled.

I manage to generate the ash report down to the session, and sql ID, but I don't found the sql execution plan, is there a way i can retrieve the past execution plan from ash report?

thanks

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

Instructions for posting

×

1. Select a discussion category from the picklist.


2. Enter a title that clearly identifies the subject of your question.


3. In the body, insert detailed information, including Oracle product and version.


Please abide by the Oracle Community guidelines and refrain from posting any customer or personally identifiable information (PI/CI).


Cloud / Fusion customers - Our Cloud community has moved! Please go to Cloud Customer Connect .


New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center