SQL Performance (MOSC)

MOSC Banner

number of binds changing execution plan

edited Jul 24, 2013 10:32PM in SQL Performance (MOSC) 5 commentsAnswered
Is there a parameter which we can set in the database that if we increase the number of bind variables in a query it's sql id and execution plan doesn't change

In my case there are 3 bind variables in query which runs in 11 sec If I replace a literal with bind variable resulting in 4 bind variables the sqlid changes and so is the execution plan.

Can we prevent such things to happen?

Regards,

Vishal

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