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 1

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


mostramistra

mostramistra

DB_CACHE_SIZE parameter: Specifies the size of the standard block buffer cache.