Re: SGA Free memory


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@xxxxxxx>
To: <oracle-l@xxxxxxxxxxxxx>
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


Other related posts: