Re: High shared pool usage

From: Marcus Mönnig <mm@xxxxxxxxxxxxxxxx>
To: ORACLE-L <oracle-l@xxxxxxxxxxxxx>
Date: Fri, 30 Sep 2011 22:44:40 +0200

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

References:

High shared pool usage
From: Ram Raman

Re: High shared pool usage
From: Marcus Mönnig

Re: High shared pool usage
From: Ram Raman

RE: High shared pool usage
From: D'Hooge Freek

Re: High shared pool usage
From: Tanel Poder

Re: High shared pool usage
From: Marcus Mönnig

Re: High shared pool usage
From: Tanel Poder

Re: High shared pool usage

Other related posts: