Multiple choice technology databases

SGA size is defined by parameter

  1. SGA_SIZE

  2. SGA_TARGET

  3. SGA_TARGET_SIZE

  4. SGA_INIT_SIZE
Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

SGA_TARGET is the initialization parameter that defines the size of the System Global Area (SGA) in Oracle 10g and later versions. This parameter allows for automatic SGA management where Oracle dynamically tunes memory components within the SGA. SGA_SIZE is not a valid parameter, and SGA_TARGET_SIZE or SGA_INIT_SIZE are not standard Oracle parameters.

Keep practicing — related questions