單項(xiàng)選擇題

Your SPFILE contains the following parameter settings：
SGA_TARGET = 8G
DB_CACHE_SIZE = 4G
SHARED_POOL_SIZE = 2G
LARGE_POOL_SIZE = 512M
JAVA_POOL_SIZE = 512M
LOG_BUFFER = 100M
SGA_MAX_SIZE = 10G
You query the V$SGA_DYNAMIC_COMPONENTS dynamic performance view and discover that the large pool component is currently sized at 1G. You want the value of the SGA_TARGET initialization parameter to 10G， but instead of specifying a value of 10G for the SGA_TARGET initialization parameter， you erroneously execute the following statement：
SQL>ALTER SYSTEM SET SGA_TARGET = 0 SCOPE = BOTH；
What is the result of this statement？（）

A. The database crashes.
B. The large pool releases 512M of memory.
C. The large pool retains 1G of allocated memory.
D. The large pool increases to 1，512M of memory.

你可能感興趣的試題

單項(xiàng)選擇題

You create an Oracle 10g database and configure the SPFILE as follows：
SGA_TARGET=2G
DB_CACHE_SIZE=512M LOG_BUFFER=50M
DB_KEEP_CACHE_SIZE=128M
You modify the SGA_TARGET initialization parameter using the following statement：
SQL>ALTER SYSTEM SET SGA_TARGET = 1G SCOPE = BOTH；
Which entity does this statement affect？（）

A. only the auto-tuned memory components
B. only the memory components that are not auto-tuned
C. both the auto-tuned memory components and the non-auto-tuned memory components
D. neither the auto-tuned memory components nor the non-auto-tuned memory components

單項(xiàng)選擇題

The SPFILE for your database contains the following parameter settings：
SGA_TARGET = 1000M
DB_CACHE_SIZE = 512M
SHARED_POOL_SIZE = 128M
LOG_BUFFER = 10M
DB_8K_CACHE_SIZE = 50M
What is the total memory that can be distributed across the auto-tuned memory components？（）

A. 940M
B. 990M
C. 690M
D. 1000M

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

你可能感興趣的試題

The SPFILE for your database contains the following parameter settings： SGA_TARGET = 1000M DB_CACHE_SIZE = 512M SHARED_POOL_SIZE = 128M LOG_BUFFER = 10M DB_8K_CACHE_SIZE = 50M What is the total memory that can be distributed across the auto-tuned memory components？（）

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

The SPFILE for your database contains the following parameter settings：
SGA_TARGET = 1000M
DB_CACHE_SIZE = 512M
SHARED_POOL_SIZE = 128M
LOG_BUFFER = 10M
DB_8K_CACHE_SIZE = 50M
What is the total memory that can be distributed across the auto-tuned memory components？（）