which one of the following conditions implicitly enables Automatic PGA Memory Management?

In Oracle 11g, by default which one of the following conditions implicitly enables Automatic
PGA Memory Management?

In Oracle 11g, by default which one of the following conditions implicitly enables Automatic
PGA Memory Management?

A.
Setting a nonzero value for SGA_TARGET

B.
Configuring Automatic Shared Memory Management

C.
Configuring Automatic Memory Management

D.
Setting a nonzero value for SGA_MAX_SIZE and PGA_AGGREGATE_TARGET

E.
None of the above

Show Hint

Leave a Reply 2

Your email address will not be published. Required fields are marked *

Vamsi

Vamsi

Automatic PGA Memory Management – For the Instance PGA

When you disable automatic memory management and enable automatic shared memory management or manual shared memory management, you also implicitly enable automatic PGA memory management. With automatic PGA memory management, you set a target size for the instance PGA. The database then tunes the size of the instance PGA to your target, and dynamically tunes the sizes of individual PGAs. Because automatic PGA memory management is the default method for the instance PGA, if you do not explicitly set a target size, the database automatically computes and configures a reasonable default.

https://docs.oracle.com/cd/B28359_01/server.111/b28318/memory.htm

Reply