Re: Surprising Performance Changes with Oracle (Long Post)

From: Mladen Gogala <>
Date: Thu, 10 Sep 2009 08:26:24 +0000 (UTC)
Message-ID: <h8ad7g$ubq$>

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.

Received on Thu Sep 10 2009 - 03:26:24 CDT

Original text of this message