Quote:
Originally posted by pando
you have to check
v$shared_pool_reserved
shared_pool_reserved_size
_shared_pool_reserved_min_alloc
probably your shared_pool_reserved_size is fragmentaTED that si why no matter how big is your shared pool you still face same problem
if that was the case you have to increase shared_pool_reserved_size or increase _shared_pool_reserved_min_alloc to a larger value so the object that is causing the problem will be pinned in shared pool instead of reserved space in shared pool
Check that shared_pool_reserved_size is about 10% of shared_pool_size. You a probabbly interested in what is _shared_pool_reserved_min_alloc, right?