Re: SGA Free memory

From: Jonathan Lewis <jonathan_at_jlcomp.demon.co.uk>
Date: Sat, 11 Feb 2006 22:03:59 -0000
Message-ID: <016201c62f57$0fd252a0$0200a8c0@Primary>

Thanks for the reference - interesting paper.

Regards

Jonathan Lewis
http://www.oracle.com/technology/community/oracle_ace/ace1.html#lewis

The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html

Cost Based Oracle: Fundamentals
http://www.jlcomp.demon.co.uk/cbo_book/ind_book.html

• Original Message ----- From: "Luca Canali" <Luca.Canali_at_cern.ch> To: <oracle-l_at_freelists.org> Sent: Friday, February 10, 2006 8:15 AM Subject: RE: SGA Free memory

Hi Jonathan,

> loop
> detach some items from end of library cache LRU
> distribute items to shared pool free list - coalescing where
possible
> check for large enough chunk on free list
> return if allocation succeeds
> end loop
>
> There may be a limit on the number of times round the loop -

Apparently the limit is 5 iterations (see Russell Green, OOW Sep. 2005)

Regards,
Luca

---

Luca Canali
Information Technology Department
European Organization for Nuclear Research CERN
CH-1211 Geneva 23

--
http://www.freelists.org/webpage/oracle-l




--
http://www.freelists.org/webpage/oracle-l

Received on Sat Feb 11 2006 - 16:03:59 CST