Database Administration (MOSC)

MOSC Banner

heavy cpu spin after upgrade

edited Dec 4, 2008 8:20AM in Database Administration (MOSC) 8 comments
Hi,
I have tried to search the community (forums) and have had no luck in finding anything.

We recently upgraded from 9.2.0.8 32bit to 10.2.0.4 64bit. Version upgrade and hardware upgrade. A query that used to run in a relatively short time, now shows an explain plan
with cost = 41 and cpu  = 8 million.

That is rather high for cpu and appears that the cpu is spinning and waiting on something.  Anyone else experience this issue with high cpu spin on queries after an upgrade or hardware upgrade?
Could this be a bug or just sql (select distinct ... from table where not in (select .. from tables)  that needs to be altered?  Yep rather vague. We are looking into the sql to see if changing will alter the explain plan, so want to know if there are any known issues out there.

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