I have a quick question about Shared_pool_reserved_size in init.ora. Oracle suggest that we should have Shared_pool_reserved_size in our database for large memory requirement like procedures compile or triggers. Oracle also suggest that shared_pool_reserved size should be = 10 % of the Shared_pool_size. My questions is what should I use for Shared_pool_reserved_min_alloc ??? Oracle only said that Shared_pool_reserved_size should be larger than Shared_pool_reserved_min_alloc.
any advise will be greatlly appreciated