Skip to Main Content
Forums

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!

If I'm enabling ASMM, is it a must that I configure the Manually sized SGA components?

GironQuengMar 30 2015 — edited Mar 31 2015

If I'm enabling ASMM, is it a must that I configure the Manually sized SGA components?

Or should I just let it be to its original size before I enable ASMM?

Would it be ok if its just set to zero? Would it affect the performance?

Here is the current size of this components on our DB:

LOG_BUFFER=2088960

DB_KEEP_CACHE_SIZE=0

DB_RECYCLE_CACHE_SIZE=0

DB_nK_CACHE_SIZE

     db_block_size= 8192

     db_16k_cache_size =0

     db_2k_cache_size =0

     db_32k_cache_size = 0

     db_4k_cache_size =0

     db_8k_cache_size =0

and we are using 11.2.0.3

I hope you can help. Thanks!
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 28 2015
Added on Mar 30 2015
#general-database-discussions
3 comments
900 views