Version: 10.2.0.4
I'm struggling to find relevant documentation for shared_pool_reserved_size when Auto Memory Management is enabled
For non-AMM, I appreciate this should be a % of shared_pool_size, but in AMM the shared_pool_size is an unknown, so how to derive the reserved size?
For context - we're running 10.2.0.4 with Auto Memory Management:
We're suffering ORA-7445 issues, which I believe can be triggered by SGA shrink operations, and we see a lot of activity in gv$sga_rezise_ops
I plan to set the shared_pool_size near the high watermark of the shared_pool_size from gv$sga_rezise_ops to reduce resize activity
So: shared_pool_size = 3GB
shared_pool_reserved_size is currently about 100MB
Should i change this to be 5% of 3GB. Or is it redundant in this scenario?
Thanks