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 2

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


jean

jean

Before enabling ASMM, should remove individual parameters from the SPFILE memory area , as set these parameters will restrict ASMM.

After seeing ASMM allocation effect , if you decide you want to adjust the distribution of values ​​for a particular component can be
That specify values ​​for these components.

If you specify a value smaller than the current value , these values ​​will be regarded as the minimum memory of each component size.

If the value specified is greater than the current value , as long as there is free memory , you can re- size memory components.

Raised the value you provide. Doing this limit can be used to automatically adjust the amount of memory, but the size of the environment need to be entered.

Luz

Luz

To limits the amount of memory available for automatic adjustment , but in the environment requires special adjustments to the size , and ASMM can not meet this need , you can use this feature.