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.

Exadata 25.2 New Features for TEMP operations

В продолжение предыдущего поста https://exadata-dba.blogspot.com/2026/02/mainworkloadtypeanalytic.html немного про новые возможности Экза-со...