Re: Surprising Performance Changes with Oracle 11.2.0.1 (Long Post)

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news: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.html
>

And what disk subsystem did you use? DAS or a shared system?

Matthias Received on Sat Sep 05 2009 - 10:17:39 CDT