SQL Performance (MOSC)

MOSC Banner

Two different execution plans are being used by single query simultaneously in RAC environment

edited Jan 5, 2015 1:29PM in SQL Performance (MOSC) 3 commentsAnswered

Hi All,

We have 3 node RAC setup and Database Version is 11.2.4.0 (with latest PSU applied). A query has two different execution plans wherein one plan is efficient and other one is causing performance slowness. The peculiar observation is that the efficient execution plan gets executed only in one node, rest of the nodes are using the poor plan. Please advise how to make other nodes also use the efficient plan. Also, let me know how to remove the inefficient plan. Sessions are getting accumulated causing chain of locks..

Note - The inefficient plan is also used in the node where the good plan is being executed.

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