nerdexam
Oracle

1Z0-052 · Question #51

Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this?

The correct answer is A. To limit the User Global Area (UGA) memory allocated to a session from the SGA. In shared server mode, the UGA is stored in the SGA rather than the PGA, so the PRIVATE_SGA profile limit controls how much SGA memory each user session can consume for its session state.

Administering User Security

Question

Your database is configured in shared server mode. However, your senior DBA asks you to modify the value of the PRIVATE_SGA limit in the profile of the users. What could be the reason for this?

Options

  • ATo limit the User Global Area (UGA) memory allocated to a session from the SGA
  • BTo limit the amount of memory to be used for the dispatcher queue of a session in SGA
  • CTo limit the amount of memory to be used for the request pool in System Global Area (SGA)
  • DTo control the amount of memory allocated in SGA for the local variables for each shared server process

How the community answered

(26 responses)
  • A
    73% (19)
  • B
    4% (1)
  • C
    8% (2)
  • D
    15% (4)

Why each option

In shared server mode, the UGA is stored in the SGA rather than the PGA, so the PRIVATE_SGA profile limit controls how much SGA memory each user session can consume for its session state.

ATo limit the User Global Area (UGA) memory allocated to a session from the SGACorrect

In dedicated server mode, the User Global Area (UGA) resides in each session's PGA, but in shared server mode the UGA is relocated into the SGA (specifically the large pool if configured, otherwise the shared pool) because session state must persist independently of any individual shared server process. The PRIVATE_SGA resource limit in a user profile caps the maximum SGA memory that a single session can allocate for its UGA, preventing one session from exhausting shared memory resources.

BTo limit the amount of memory to be used for the dispatcher queue of a session in SGA

Dispatcher queue memory is a shared infrastructure element managed by the dispatcher process for all sessions collectively, not a per-user SGA allocation governed by a profile limit.

CTo limit the amount of memory to be used for the request pool in System Global Area (SGA)

The request pool is a global shared structure used by all sessions to queue calls to available shared server processes and is not allocated on a per-user basis.

DTo control the amount of memory allocated in SGA for the local variables for each shared server process

Local variables for individual shared server processes reside in each process's own PGA, not in the SGA, and cannot be limited on a per-user basis through PRIVATE_SGA.

Concept tested: PRIVATE_SGA profile limit controlling UGA in shared server mode

Source: https://docs.oracle.com/cd/E11882_01/server.112/e41084/statements_6014.htm

Topics

#PRIVATE_SGA#shared server#UGA#user profile

Community Discussion

No community discussion yet for this question.

Full 1Z0-052 Practice