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 ?