IDNLearn.com provides a reliable platform for finding accurate and timely answers. Ask your questions and get detailed, reliable answers from our community of knowledgeable experts.

What happens when the PGA memory used by an instance exceeds the PGA_AGGREGATE_LIMIT?
A) The instance shuts down automatically.
B) Additional PGA memory is allocated beyond the limit.
C) Oracle starts to kill sessions to free up memory.
D) Performance improves as more memory is used.