Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

A question about LRU in shared pool

709874Aug 23 2009 — edited Aug 26 2009
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.
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Sep 23 2009
Added on Aug 23 2009
4 comments
947 views