FAQ
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 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

Search Discussions

Discussion Posts

Previous

Related Discussions

Discussion Navigation
viewthread | post
posts ‹ prev | 3 of 3 | next ›
Discussion Overview
grouporacle-l @
categoriesoracle
postedJul 6, '07 at 10:26a
activeJul 6, '07 at 1:12p
posts3
users3
websiteoracle.com

People

Translate

site design / logo © 2022 Grokbase