Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

shared_pool_reserved_size in a AMM DB

PD81Sep 8 2017 — edited Sep 8 2017

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

This post has been answered by Stefan Koehler on Sep 8 2017
Jump to Answer
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Oct 6 2017
Added on Sep 8 2017
5 comments
661 views