Which statement is true in this scenario?

Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true in this scenario?

Automatic Shared Memory Management (ASMM) has been enabled for your database instance. The initialization parameters for the components that are managed by ASMM are not set. After observing the effects of ASMM, you executed the following command:
SQL> ALTER SYSTEM SET DB_CACHE_SIZE = 100M;
Which statement is true in this scenario?

A.
The minimum memory size for the database buffer cache is set to 100 MB.

B.
The maximum memory size that can be obtained by the database buffer cache during ASMM is set to 100 MB.

C.
The minimum memory size allocated for a server process in the database buffer cache in dedicated mode is set to 100 MB.

D.
The maximum memory size from the database buffer cache that can be released for dynamic distribution during ASMM is set to 100 MB.



Leave a Reply 0

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