SQL Performance (MOSC)

MOSC Banner

using bind variables+capturing sql plan

edited Sep 26, 2015 10:01AM in SQL Performance (MOSC) 2 commentsAnswered

After setting capture sql plans to true, I running a select sql using bind variables, after a few executions the plan is captured with the bind variable entered at run time

How can the plan be captured with a bind variable or is this expected behavior?

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