Database Administration (MOSC)

MOSC Banner

Plan Flushed from Cursor cache

Dear Experts,

I am trying to simulate a scenario.

I am flushing everything from shared pool (Cursor cache)

And then trying to find the best plan for the SEELECT Query from DBA_HIST View.

In case DBA_HIST view contains multiple plans for same SQL statement For e.g

Please assume that we have 5 plans and response time

PLAN 1 --> Cost and response time is 2 secs

PLAN 2 --> Cost and response time is 2.02 secs

PLAN 3 --> Cost and response time is 2.08 secs

PLAN 4 --> Cost and response time is 2.52 secs

PLAN 5 --> Cost and response time is 2.30 secs

After flushing shared pool , How do i pick/find the cost effective plan for the SELECT Query ?

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