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.

How to disable/setup autostart parameters for specified instance ?

Q: We have a 4-node RAC. I need to disable autostart of the DB on one node only.    How to do it and how to see autostart parameters, confir...