SQL Performance (MOSC)

MOSC Banner

Plan hash Change during CPU

edited Feb 10, 2020 11:49AM in SQL Performance (MOSC) 1 commentAnswered

Hi

My plan hash change during CPU utilization went up to 98% to 100%

02-09 23        4096783119          167      218,903        2,125,269            585          2,700,582      173,091,540      176,624,019         1.057629     148680

02-10 02        2863109163          326      294,608       20,344,617      5,066,898        739,858,602   20,379,127,068   26,353,705,580        80.839588     148687

02-10 03        2863109163          230      292,361       14,393,963      6,518,641      1,145,930,155   20,971,806,211   28,186,999,441       122.552171     148688

                2863109163          237      246,580       15,064,292      4,686,593        753,191,458   17,921,344,461   22,748,672,504        95.985960     148689

02-10 04        4096783119          338      295,753        2,641,677            981          3,741,645      269,148,212      288,527,270          .853631     148690

                4096783119          171      139,301        1,185,109            509            375,417       92,312,267       92,836,165          .542902     148691

02-10 05        4096783119          407      582,758        5,901,742          1,336            965,200      510,494,225      515,047,395         1.265473     148692

May I know what can cause this. Note that the SQL_ID has no baseline and has not been PINNED.

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