Re: SGA Free memory

  • From: "Jonathan Lewis" <jonathan@xxxxxxxxxxxxxxxxxx>
  • To: <Luca.Canali@xxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
  • Date: Sat, 11 Feb 2006 22:03:59 -0000

Thanks for the reference - interesting paper.


Jonathan Lewis

The Co-operative Oracle Users' FAQ

Cost Based Oracle: Fundamentals

----- 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,

       detach some items from end of library cache LRU
       distribute items to shared pool free list - coalescing where
       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)


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


Other related posts: