Re: Pentium M and Oracle Performance

Christoph Breitkopf wrote:
> Let me list a few results. "Import" the the elapsed import time
> in seconds for the Benchmark database. This has a closer correlation
> to disk (write) performance than our code, and should not be too
> dependant on out data. All systems ran Oracle 8.1.7.4.0.
>
> Score Import System
>  133    70   F/S Lifebook E4010, Centrino 1.6GHz, 512MB RAM, external
200GB USB2 disk, Win XP
>  116    90   F/S Lifebook E4010, Centrino 1.6GHz, 512MB RAM, 60 GB 2.5"
IDE, Win XP
>  114    47   Compaq ProLiant ML530 G2, 2xPentium4 Xeon 2.4GHz, 3GB RAM,
10x36GB RAID1, Win2K
>  109    56   Dell Dimension 4600, Pentium4 2.6GHz, 512MB RAM, IDE disk,
Win XP
>   87    77   F/S Primergy, 2xPentium3 1266MHz, 2GB RAM, EMC^2 storage
array, Win2K
>   82    52   Compaq ProLiant ML370 G3, 2xPentium4 Xeon 2GHz, 1GB RAM, HP
Smartarray 5302/128 (6x36GB RAID 5), Win2K
>   45   135   HP rp5400, PA8600 540MHz, 1GB RAM, ?SCSI (no RAID), HP-UX 11
>   33   127   Sun Fire 280R, 2xUSIII 750MHz, 2GB RAM, SUN StoreEdge A1000,
Solaris 8
>   21   237   Sun Ultra5/400,  USIIi 400MHz, 256MB RAM, 9GB IDE, Solaris 8
>   20   242   HP Brio, PentiumII 350MHz, 256MB RAM, 2x9GB SCSI, Linux

Have you done any checking with regards to oracle internals? E.g. buffering,
query hints, etc.

What does the sql cache tell you?


greetings,