Saturday, August 11, 2018

ASM SGA sizing

The query from customer DBA :

" Hello,
We plan to install X TB database .. I didn't find the rule for ASM SGA sizing.

What values i need to set for the ASM instance:
sga_max_size =
sga_target     =   ? "


I found the note 437924.1 and 
the only source in the documentation, which point to the ASM sga sizing:




So, for example, for 1T database with Normal redundancy customer have to yield 24-25 MB of ASM SGA.


No comments:

Post a Comment

Note: Only a member of this blog may post a comment.

ASM: How much time the rebalance will continue?

When planning  ASM  changes/downtimes every DBA need to answer the query  "how much time the rebalance will continue ?". It turns...