Re: Shared Pool vs Buffer Cache with ASMM

Richard,

What are taking space in the shared pool?

Look at v$sql for queues without binds, many child cursors, etc...

On 7/6/07, Richard Saints <saints.richard_at_gmail.com> wrote:
>
> Hello to you all,
>
>
> We use Automatic Shared Memory Management and have a SGA target = to the SGA
> Max Size = 1336Mb. ASMM always gave a bigger slice of memory to the Buffer
> Cache (about 70%), but in the last 2 weeks I noticed that the value of the
> Shared Pool started to increase and now it's bigger than Buffer Cache (a
> slice of 49,7%).
>

-- 
Alex Fatkulin, The Pythian Group
http://www.pythian.com/blogs/author/alexf/
--
http://www.freelists.org/webpage/oracle-l