Re: High shared pool usage

From: Marcus Mönnig <mm_at_marcusmoennig.de>
Date: Fri, 30 Sep 2011 22:44:40 +0200
Message-ID: <CAFuw4vk3VPMDx5kvp4S2ys9XgWB4qvuxighcoUJ+cDaMZdCeXw_at_mail.gmail.com>

Thanks, Tanel! Your addional explanation cleared it up for me again!

> The "composite granule"
> code isn't probably able to reclaim that memory back from buffer cache use
> to shared pool - or doesn't realize that it would be good to shrink the
> buffer cache...

This possibly is the culprit of what I observed and called a memory leak. My expectation would be that at least when you get ORA-04031 errors, the instance should know that it would be better to reclaim space used by the buffer cache.

Cheers and happy OOW!
Marcus

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

Received on Fri Sep 30 2011 - 15:44:40 CDT