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
SQL used to delete rows?
EXPLAIN PLAN?
CBO/RBO?
Received on Sat Feb 07 2004 - 20:05:13 CST
