Based on this info, I would look at following on both systems, in this
order:
- Anything else running in database and on the server (other than Oracle).
- Oracle files and on what type of disks system.
- Index info, trigger code?, constraints?, parallel degree?, chaining?,
extents
- SGA
- OS messages?, Oracle alert.log messages?
The above shouldn't take long to check to ensure equal environments, which I
suspect it is not.
--
"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 Sun Feb 08 2004 - 03:26:15 CST
