Re: MSWIn, 9i -> 11G Upgrade, 100% CPU Usage, No Workload
From: joel garry <joel-garry_at_home.com>
Date: Wed, 17 Apr 2013 08:37:50 -0700 (PDT)
Message-ID: <11b6278d-4fb0-475e-9beb-cca9ac0ac3e5_at_c5g2000yqh.googlegroups.com>
On Apr 17, 8:25 am, 100111..._at_gmail.com wrote:
> Hi Joel,
>
> > Sounds like you should run a 15 minute statspack at good and bad times
> > and see what that has to say about it. Google Jonathan Lewis
> > Statspack if you need more info. Something is going plan-crazy I
> > would guess.
>
> At one point I thought bad stats too but....
> We've taken AWR snapshots and reports multiple times. All the sql runs normally.
> We have imported/exported stats during normal operation and when the above happens. Applying the good and bad stats seems to have no bearing on when the problem happens. Notice I say seems :(
>
> Thanks for your thoughts
> Dave
Date: Wed, 17 Apr 2013 08:37:50 -0700 (PDT)
Message-ID: <11b6278d-4fb0-475e-9beb-cca9ac0ac3e5_at_c5g2000yqh.googlegroups.com>
On Apr 17, 8:25 am, 100111..._at_gmail.com wrote:
> Hi Joel,
>
> > Sounds like you should run a 15 minute statspack at good and bad times
> > and see what that has to say about it. Google Jonathan Lewis
> > Statspack if you need more info. Something is going plan-crazy I
> > would guess.
>
> At one point I thought bad stats too but....
> We've taken AWR snapshots and reports multiple times. All the sql runs normally.
> We have imported/exported stats during normal operation and when the above happens. Applying the good and bad stats seems to have no bearing on when the problem happens. Notice I say seems :(
>
> Thanks for your thoughts
> Dave
Just to be clear, when you say "machines" you don't mean more HyperV?
jg
-- _at_home.com is bogus. http://searchoracle.techtarget.com/news/2240181880/Oracle-competition-is-worth-a-look-Collaborate-attendees-sayReceived on Wed Apr 17 2013 - 17:37:50 CEST