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 *