Database Memory & 4030/4031 (MOSC)

MOSC Banner

Automatic shared pool management

edited Jun 14, 2012 9:02AM in Database Memory & 4030/4031 (MOSC) 23 commentsAnswered
Hi,

One of our test databse in In automatic shared pool management SGA_TARGET=800M and SGA_MAX_SIZE=800M

1) I can see shared pool usage is around 625 M and shared pool allocation is arund 800 M in average when SHARED_POOL_SIZE= 0
But I can see shared pool usage is around 325 M when and shared pool allocation is arund 400 M when SHARED_POOL_SIZE= 350M.

Now I shall like to ask below question  :

A) How can the shared pool usage become so small when there is a minimum setting for shared pool size in comparison to the  shared pool usage when SHARED_POOL_SIZE= 0  for the nearly same sqls run and in the same duration .

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center