| A question about LRU in shared pool [message #419538] |
Mon, 24 August 2009 02:21  |
serenaender
Messages: 4
Registered: August 2009
|
Junior Member |
|
|
Hi,
I have a doubt about how LRU algorythm works. LRU is supossed to ages out unpinned recreatable chunks when it needs free space. So, as there is enough space LRU will not work.
However, why don't we always notice shared pool memory usages close to 100%? Is there any other event that triggers LRU apart from this lack of memory such time in shared pool?
As i guess, if LRU only works when there isn't enough free space and ages out the space that needs, the shared pool should be like a bucket filling up with water. However, the optimal memory usage is supossed to be close to 70%.
Thanks before hand.
|
|
|
|
|
|
|
|
| Re: A question about LRU in shared pool [message #420268 is a reply to message #419575] |
Fri, 28 August 2009 00:05  |
trantuananh24hg
Messages: 744
Registered: January 2007
Location: Ha Noi, Viet Nam
|
Senior Member |
|
|
| serenaender wrote on Mon, 24 August 2009 17:54 | I usually use Statspak or AWR reports. In the shared pool statistics section appears the shared pool memory usage.
|
What's kind of shared_pool statistics on your AWR and Statspack?
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
