SQL Performance (MOSC)

MOSC Banner

Sql Baseline not getting accepted after evolution

edited Dec 3, 2014 10:10AM in SQL Performance (MOSC) 1 commentAnswered

Hi Gurus,

I have sql baseline and i found another plan to be good after evolution but oracle is not accepting it.Want to find the reason why is it not doing accepting the plan which is better compared to the one existing.


    ------------------------------------------------------------------------------- Evolve SQL Plan Baseline Report -------------------------------------------------------------------------------  Inputs: ------- PLAN_LIST  = SQL_PLAN_97w38w75w14ptcf55f016 TIME_LIMIT = DBMS_SPM.AUTO_LIMIT VERIFY     = YES COMMIT     = YES  Plan: SQL_PLAN_97w38w75w14ptcf55f016 ------------------------------------ Plan was verified: Time used 2.83 seconds. Plan failed performance criterion: 1.33 times better than baseline plan.  Baseline Plan      Test Plan       Stats Ratio -------------      ---------       ----------- Execution Status:              COMPLETE       COMPLETE Rows Processed:                     615            615 Elapsed Time(ms):               520.235        433.235               1.2 CPU Time(ms):                   516.921        432.434               1.2 Buffer Gets:                     176299         132074              1.33 Physical Read Requests:               0              0 Physical Write Requests:              0              0 Physical Read Bytes:                  0              0 Physical Write Bytes:                 0              0 Executions:                           1              1  ------------------------------------------------------------------------------- Report Summary

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