Re: Surprising Performance Changes with Oracle 11.2.0.1 (Long Post)
From: Gerard H. Pille <ghpille_at_hotmail.com>
Date: Thu, 10 Sep 2009 02:20:49 -0700 (PDT)
Message-ID: <6407340b-7370-4343-999b-83f79f0515e7_at_a7g2000yqo.googlegroups.com>
On 10 sep, 10:26, Mladen Gogala wrote:
Date: Thu, 10 Sep 2009 02:20:49 -0700 (PDT)
Message-ID: <6407340b-7370-4343-999b-83f79f0515e7_at_a7g2000yqo.googlegroups.com>
On 10 sep, 10:26, Mladen Gogala wrote:
>
> Question: was direct I/O enabled here? If not, the blocks may have been
> in the system buffer cache in which case oracle would still report them
> as "physical reads" but blocks would be coming from memory instead.
>
Why do you ask this? Charles clearly states that it was not. Will you believe him next time?? Received on Thu Sep 10 2009 - 04:20:49 CDT