Multiple choice technology databases

How we can configure PGA area in Oracle?

  1. Specifying size of memory for each server process

  2. Specifying size of total memory for all server process

  3. No way to define

  4. Specifying size of seperate memory and total memory for all server processes

Reveal answer Fill a bubble to check yourself
B Correct answer
Explanation

PGA memory is configured using the PGA_AGGREGATE_TARGET parameter, which specifies the total memory for all server processes combined. You cannot specify memory per individual server process. Oracle dynamically allocates PGA memory from this aggregate target to individual processes as needed, optimizing overall memory usage.