Sql Baseline not getting accepted after evolution
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
1