Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Why Oracle performance on Sun V880 is even worse than PC server?
Hello Life Learner,
First step is to generate statspack report for the time of the delete test. This will help to find out where oracle spends most of the time during delete.
If you can please put report for the group review.
Another thing: make sure than SUN database is set up the exactly the same way as the one on HP. Checking statspack report then can help to pinpoint what OS tuning is needed.
Hope these would help you to start investigation.
Regards,
Ron
DBA Infopower
http://www.dbainfopower.com
Standard disclaimer:
http://www.dbainfopower.com/dbaip_advice_disclaimer.html
"Life Learner" <powere2e_at_yahoo.com> wrote in message
news:f966c546.0402071751.3eec1333_at_posting.google.com...
> 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
Received on Sat Feb 07 2004 - 20:49:14 CST