Re: Surprising Performance Changes with Oracle 11.2.0.1 (Long Post)
From: Mladen Gogala <gogala.mladen_at_bogus.email.invalid>
Date: Thu, 10 Sep 2009 08:26:24 +0000 (UTC)
Message-ID: <h8ad7g$ubq$3_at_solani.org>
Na Wed, 09 Sep 2009 17:12:12 -0700, Charles Hooper napisao:
Date: Thu, 10 Sep 2009 08:26:24 +0000 (UTC)
Message-ID: <h8ad7g$ubq$3_at_solani.org>
Na Wed, 09 Sep 2009 17:12:12 -0700, Charles Hooper napisao:
> The first execution completed in 5 minutes and almost 5 seconds. The
> second execution completed in 19.39 seconds with a nearly identical
> value for physical block reads.
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.
-- http://mgogala.freehostia.comReceived on Thu Sep 10 2009 - 03:26:24 CDT