SQL Performance (MOSC)

MOSC Banner

Baseline created with a different explain plan for the same qurey.

edited May 11, 2018 6:09PM in SQL Performance (MOSC) 7 commentsAnswered ✓

HI Oracle Gurus,

I am facing an issue where I am in process of migrating schema from one database 11.2.0.2 to new database 11.2.0.4. One sql is using different plan.

I thought of creating a baseline plan but When I create the baseline it in using a different plan that with what it is running. Can you please suggest. I am copying my results here.

First I am checking the plain what my query is using with display_cursor. It gives me the desired plan.

But When I create the baseline with same sql_id it creates the baseline with a different plan which show more CPU time. Problem is with step 11 where it is doing a full table scan instead of Index scan as shown is current execution plan. I marked the step 11 in bold. Please let me know your thoughts on this.

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

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center