You configure your database Instance to support shared server connections. Which two
memory areas that are part of PGA are stored in SGA instead, for shared server
connection?
A.
Location of a part of the runtime area for SELECT statements
B.
User session data
C.
Stack space
D.
Private SQL area
E.
Location of the runtime area for DML and DDL Statements
BD
Rather than just repeat the answer given on the site, Oracle documentation states:
https://docs.oracle.com/cd/E11882_01/server.112/e40540/memory.htm#CNCPT1222
“The location of the private SQL area depends on the connection established for the session. If a session is connected through a shared server, then part of the private SQL area is kept in the SGA.”
“The UGA is session memory, which is memory allocated for session variables, such as logon information, and other information required by a database session. Essentially, the UGA stores the session state.
…
The UGA must be available to a database session for the life of the session. For this reason, the UGA cannot be stored in the PGA when using a shared server connection because the PGA is specific to a single process. Therefore, the UGA is stored in the SGA when using shared server connections, enabling any shared server process access to it. When using a dedicated server connection, the UGA is stored in the PGA.”
Therefore, the given answer BD is correct.