單項(xiàng)選擇題

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 effectsof 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 100mb
C.The minimum memory size allocated for a server process in the database buffer cache in dedicated modeis set to 100 mb.
D.The maximum memory size from the database buffer cache that can be released for dynamic distributionduring ASMM is set to 100 mb

你可能感興趣的試題

單項(xiàng)選擇題

Which statement is true about the Manageability Monitor （MMON） background process（）

A.It transfers statistics from memory to disk at regular intervals.
B.It coordinates the rebalance activity for disk groups when ASM is used.
C.It communicates with the Automatic Storage Management （ASM） instance on behalf of the database Instance.
D.It performs dynamic memory management when Automatic Shared Memory Management is enabled for the Database instance

多項(xiàng)選擇題

Which two statements are true regarding the SGA_TARGET initialization parameter（）

A.It can be increased up to the value of the SGA_MAX_SIZE parameter.
B.Increasing the value of the SGA_TARGET parameter distributes the increased memory among all the Autotuned components.
C.Reducing the value of the SGA_TARGET parameter deallocates memory from both autotuned and Manually sized components.
D.Increasing the value of SGA_TARGET up to the value of SGA_MAX_SIZE disables the automatic shared Memory management feature.

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美 国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线

你可能感興趣的試題

Which statement is true about the Manageability Monitor （MMON） background process（）

Which two statements are true regarding the SGA_TARGET initialization parameter（）

日韩欧美亚洲 _ 欧美亚洲一区 _ 日本亚洲欧美 _ 亚洲精品欧美国产白袜脚足J棉袜在线观看_亚洲熟妇av一区二区三区_久久天天躁狠狠躁夜_精品众筹模特私拍在线