Re: Surprising Performance Changes with Oracle (Long Post)

From: Jonathan Lewis <>
Date: Sat, 5 Sep 2009 07:04:45 +0100
Message-ID: <>

> "Charles Hooper" <> wrote in message
> I am working on an Oracle performance related project, so I thought
> that I would compare the performance of Oracle database (on
> 64 bit Linux), (on 64 bit Windows), and (on 64 bit
> Linux).



Interesting figures.
A couple of follow-on questions:

    How much memory in the machine ?
    How many CPUs
    Were you running the client locally - ipc or tcp     How much CPU usage "outside" Oracle in each test     Any significant variation in 'prefetch' blocks     Any other significant variation in stats


Jonathan Lewis

Author: Cost Based Oracle: Fundamentals

The Co-operative Oracle Users' FAQ 
Received on Sat Sep 05 2009 - 01:04:45 CDT

Original text of this message