Re: Surprising Performance Changes with Oracle 11.2.0.1 (Long Post)
From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 5 Sep 2009 07:04:45 +0100
Message-ID: <stydnRbjqr7nYjzXnZ2dnUVZ8nSdnZ2d_at_bt.com>
Date: Sat, 5 Sep 2009 07:04:45 +0100
Message-ID: <stydnRbjqr7nYjzXnZ2dnUVZ8nSdnZ2d_at_bt.com>
> "Charles Hooper" <hooperc2000_at_yahoo.com> wrote in message
> news:1ea99c67-8713-4ece-a0f5-85f66851b016_at_v2g2000vbb.googlegroups.com...
> I am working on an Oracle performance related project, so I thought
> that I would compare the performance of Oracle database 11.1.0.6 (on
> 64 bit Linux), 11.1.0.7 (on 64 bit Windows), and 11.2.0.1 (on 64 bit
> Linux).
...
Charles,
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
-- Regards Jonathan Lewis http://jonathanlewis.wordpress.com Author: Cost Based Oracle: Fundamentals http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html The Co-operative Oracle Users' FAQ http://www.jlcomp.demon.co.uk/faq/ind_faq.htmlReceived on Sat Sep 05 2009 - 01:04:45 CDT