Re: Does optimizer's behaviour change with this ?

From: anacedent <anacedent_at_hotmail.com>
Date: Mon, 05 Jul 2004 13:24:49 -0700
Message-ID: <oOiGc.10225$nc.5942@fed1read03>

Spendius wrote:

> joel-garry_at_home.com (Joel Garry) wrote:
>

>>Is it the SGA much larger?  You may be running into the "must do 
>>more work in the SGA because some data constructs are now much 
>>larger" issue.
>>
>>And of course, what else have you changed?  Are you using OPS?

>
> We're not using OPS. I forgot to precise that we also switched
> from 4K-big blocks to 16K.
>
>

>>and etc and etc.)  If the cpu's are not 100% all the time, there 
>>may not even be a problem - are things running faster?

>
> Oo yes !, incredibly faster, the client is happy: but as they pay
> their license on a CPU-consumption basis, they're now... complaining
> they're going to pay too much and want our team to keep on tuning
> to reduce this CPU usage...

This might be a classic case of Compulsive Tuning Disorder. Received on Mon Jul 05 2004 - 15:24:49 CDT