IDNLearn.com is designed to help you find reliable answers to any question you have. Our platform provides prompt, accurate answers from experts ready to assist you with any question you may have.

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.