SQL Performance (MOSC)

MOSC Banner

SQL Performance

edited Jun 2, 2015 10:07AM in SQL Performance (MOSC) 1 commentAnswered

I am little bit confused as I see  2392555633 would be the best PHV to create a sql baseline or sqlprofile but when I see explain plan 2392555633 seems very bad PHV for baseline creation and  3456048781 looks good one.

PLAN_HASH_VALUE AVG_ET_SECS

--------------- -----------

     2392555633       2.396-------Here it sems good PHV for baseline

     2317165185       8.255

     3776114006       38.08

      895145127     106.062

     1822069265     108.826

      305450620     410.778

     3456048781     498.286

     2792127502     650.387---Here it seems bad PHV for base line

Please find plan for both PHV and suggest why it is so?

3456048781:--Shows best plan

Plan hash value: 3456048781

-----------------------------------------------------------------------------------------------------------

| Id  | Operation                      | Name                     | Rows  | Bytes | Cost (%CPU)| Time     |

-----------------------------------------------------------------------------------------------------------

|   0 | INSERT STATEMENT               |                          |       |       |     1 (100)|          |

|   1 |  LOAD TABLE CONVENTIONAL       |                          |       |       |            |          |

|   2 |   NESTED LOOPS ANTI            |                          |     1 |   244 |     1   (0)| 00:00:01 |

|   3 |    NESTED LOOPS ANTI           |                          |     1 |   214 |     0   (0)|          |

|   4 |     TABLE ACCESS BY INDEX ROWID| Table     |     1 |   200 |     0   (0)|          |

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