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