Re: Is 10g much slower than 9i?

Check how your IO is spread out on both machines, and/or collect statspack for running jobs and compare

On 16 Mar 2004 09:05:29 -0800, ramon_at_conexus.net (Ramon F Herrera) wrote:

>Daniel Morgan <damorgan_at_x.washington.edu> wrote in message
>> Not my experience at all. I'm seeing 20-30% increases in almost
>> everything I do.
>
>Well, maybe I am comparing apples and oranges. See my points
>of comparison below. The older machine is still in production
>and the newer one is under "observation" because I am less
>than thrilled with its current performance. I both cases I
>used Werner Puschitz' instructions to the letter, as far
>as kernel configuration, installation, etc.
>
>Old Oracle Server:
>Dell PowerEdge 2550 with 1 2.4 GHz CPU and 2.5 GB RAM
>PERC RAID chip
>RedHat 9
>Oracle 9iR2
>
>
>New Oracle Server:
>Dell PowerEdge 2650 with 2 3.0 GHz CPUs and 2 GB RAM
>Adaptec RAID card with full cache
>RedHat Enterprise Linux 3
>Oracle 10gR1
>
>
>The new server is substantially better in every respect
>-except for having less RAM. Could this be what's slowing it down?
>I see no swapping at all.
>
>A typical daily job that takes 7-8 minutes in the old machine,
>takes 40 minutes in the new one. The old -and presumably less
>capable- server is up to ten times faster for some jobs.
>I have tested my own SQL procedures and basic Oracle tasks
>such as indx creation. The old guy always beats the new one.
>
>I understand that RedHat and Oracle did a lot of work in
>order to improve Linux and produce the RHEL, so it should
>be much better matched to the Oracle database needs the RH9.
>
>Any ideas, suggestions?
>
>-Ramon

.......
We use Oracle 8.1.7.4 on Solaris 2.7 boxes remove NSPAM to email Received on Tue Mar 16 2004 - 13:56:03 CST