Re: SGA

From: Niall Litchfield <niall.litchfield_at_gmail.com>
Date: Thu, 24 Jun 2004 08:47:22 +0100
Message-ID: <7765c8970406240047775b3818@mail.gmail.com>

On Wed, 23 Jun 2004 20:56:13 -0600, Justin Cave <justin_at_askddbc.com> wrote:
> For full table scans, Oracle always puts the blocks at the least recently
> used side of the buffer cache, so you only cache 1 block. If Oracle has to
> process more rows than it can cache, it simply ages out the older blocks.

Except that the FTS will be done with a multi-block read. And as other activity is going on at the same time some of the blocks scanned by the FTS will in all likelihood age out faster than others.

Cheers

-- 
Niall Litchfield
Oracle DBA
http://www.niall.litchfield.dial.pipex.com
----------------------------------------------------------------
Please see the official ORACLE-L FAQ: http://www.orafaq.com
----------------------------------------------------------------
To unsubscribe send email to:  oracle-l-request_at_freelists.org
put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------

Received on Thu Jun 24 2004 - 02:44:04 CDT