Performance Tuning - Question 026

Which of these accurately describes how the UGA is configured?

A . In both shared server and dedicated server environments, the session stack space is kept in the SGA.

B . The sort areas and private SQL areas are included in the SGA in the dedicated server environment.

C. In both shared server and dedicated server environments, the session stack space is kept in the PGA.

D . The sort areas and private SQL areas are included in the PGA, regardless of the server configuration.

Explanation:

Answer C: By definition, the session stack space is kept in the PGA, whether the process memory is assigned to a shared server or a dedicated server. The sort areas and private SQL areas are stored in the PGA for dedicated servers, and in the SGA for shared servers.