Re: Why Oracle performance on Sun V880 is even worse than PC server?

Life Learner wrote:
>
> The old one is HP LH6000 with dual CPU,2G RAM, Oracle 8.1.7.
> The new one is SUN V880 with 6 CPU,16G RAM, Oracle 8.1.7.4(64 bit).
>
> Deleting a million rows table on HP took 3 minutes, Sun took as much
> as twice.
>
> Oracle is running without archiving, tablespaces are set nologging.
>
> I think this is definitely not expected behaviour, but where should I
> start to investigate? or what else info should I report here? TIA

The slowest parts of a computer are it's disk subsystem and it's network subsystem. How 'bout describing those. And how they interact with memory, specifically your SGA config. (If direct attached disk, the network subsystem is probably irrelevant.)

Other questions I'd be askin' include - do we have any idea how many CPUs were actually available to the Oracle operations? and was anything else happenin' on the machines?

(You'd be surprised how many times people notice performance differences: the big 'spensive machine is slower, we've only got 8 instances and 14 applications running on it. The little machine seems much faster - since it's smaller we didn't allow anyone to load up another instance.)

I'd probably start looking at some [additional] StatsPack & base Performance Tuning training.
/Hans Received on Sat Feb 07 2004 - 21:59:08 CST