Re: SGA
- From: Niall Litchfield <niall.litchfield@xxxxxxxxx>
- To: oracle-l@xxxxxxxxxxxxx
- Date: Thu, 24 Jun 2004 08:47:22 +0100
On Wed, 23 Jun 2004 20:56:13 -0600, Justin Cave <justin@xxxxxxxxxxx> 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@xxxxxxxxxxxxx
put 'unsubscribe' in the subject line.
--
Archives are at //www.freelists.org/archives/oracle-l/
FAQ is at //www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Other related posts:
