Re: Shared Pool vs Buffer Cache with ASMM
- From: "Alexander Fatkulin" <afatkulin@xxxxxxxxx>
- To: saints.richard@xxxxxxxxx
- Date: Fri, 6 Jul 2007 09:12:03 -0400
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@xxxxxxxxx> 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/
--
//www.freelists.org/webpage/oracle-l
Other related posts:
