Re: Buffer use under Oracle
- From: "K Gopalakrishnan" <kaygopal@xxxxxxxxx>
- To: <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 12 May 2004 21:16:55 +0530
Cary:
I don't think this is right unless I am reading between lines ;).
Cloned buffers are always kept in the cold end in the new alogorithm
and they are ready to be flushed when ever there is a demand for
new buffers. The CR buffers are kept in the FROZEN end (note the
word freeze in the parameter, it is not cold. Freeze)
Of course the behavior can be controlled by _db_aging_freeze_cr
parameter.
KG
> >Why aren't the old ones freed when a new one is created?
>
> ...because of Oracle's LRU buffer cache management algorithm.
> Currently-executing queries may "like" having a slightly older CR copy =
> of a
> newly modified block in the buffer cache. Such a block will tend to =
> remain
> cached as long as some session keeps using it. Those blocks are in your
> buffer cache because your application needs them.
>
----------------------------------------------------------------
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:
