heavy cpu spin after upgrade
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.
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.
0