Tuning shared_pool_reserved_size

select case when (request_failures>0 and request_misses>0)
then ‘increase reserved’
–
when (request_failures>0 and free_space*2>(select to_number(value) from v$parameter where name=’shared_pool_reserved_size’))
then ‘increase the shared_pool_size’
–
when (request_failures=0 and free_space*2>(select to_number(value) from v$parameter where name=’shared_pool_reserved_size’))
then ‘decrease the shared_pool_reserved_size’
–
else
‘If your suffering 4031 – Pin Objects and if possible increase shared_pool’
end
from v$shared_pool_reserved;

You may also check the  _shared_pool_reserved_min_alloc

 

Advertisement