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.

Does DEALLOCATE UNUSED or SHRINK SPACE will free space occupied by LOB segment?

Lets check how it works. My env is DB 19.20@Linux-x64 1) I created the table with 4 LOB columns of 4 different LOB types: BASICFILE BLOB, BA...