多項(xiàng)選擇題

You are enabling the Automatic Shared Memory Management feature in the Oracle Database 10g to ensure that the important memory structures of the System Global Area （SGA） are automatically adjusted depending on the database workload. You are using Enterprise Manager 10g to enable this feature. You are currently on the Administration tab page.
Which two links should you click to go to the Memory Advisor page？（）

A. Advisor Central
B. Global Attributes
C. Resource Monitors
D. Memory Parameters
E. Database Usage Statistics
F. All Initialization Parameters
G. Automatic Workload Repository

你可能感興趣的試題

單項(xiàng)選擇題

You have included the following parameter setting in your server parameter file： PGA_AGGREGATE_TARGET = 800M
SORT_AREA_SIZE = 100M
HASH_AREA_SIZE = 100M
BITMAP_MERGE_AREA_SIZE = 100M
CREATE_BITMAP_AREA_SIZE = 100M
Which statement is true？（）

A. All the *_AREA_SIZE parameters are ignored.
B. The Automatic PGA Memory Management feature cannot be disabled.
C. The total Program Global Area （PGA） memory cannot be manually increased above 800M.
D. The total memory for the PGA can automatically exceed 800M using the Automatic PGA Memory Management feature.

單項(xiàng)選擇題

You have included the following parameter settings in your SPFILE：
SGA_MAX_SIZE=8G
SGA_TARGET=6G
DB_CACHE_SIZE=2G
SHARED_POOL_SIZE=1G
LOG_BUFFER=64M
DB_KEEP_CACHE_SIZE=960M
Which statement is true if you modify the SGA_TARGET initialization parameter？（）

A.The SGA_TARGET initialization parameter cannot be set to a value greater than 8G
B. The DB_CACHE_SIZE initialization parameter cannot be set to a value less than 2G
C. The DB_CACHE_SIZE initialization parameter cannot be set to a value greater than 2G
D. The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value greater than 960M
E. The DB_KEEP_CACHE_SIZE initialization parameter cannot be set to a value less than 960M

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

你可能感興趣的試題

You have included the following parameter setting in your server parameter file： PGA_AGGREGATE_TARGET = 800M SORT_AREA_SIZE = 100M HASH_AREA_SIZE = 100M BITMAP_MERGE_AREA_SIZE = 100M CREATE_BITMAP_AREA_SIZE = 100M Which statement is true？（）

You have included the following parameter settings in your SPFILE： SGA_MAX_SIZE=8G SGA_TARGET=6G DB_CACHE_SIZE=2G SHARED_POOL_SIZE=1G LOG_BUFFER=64M DB_KEEP_CACHE_SIZE=960M Which statement is true if you modify the SGA_TARGET initialization parameter？（）

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

You have included the following parameter setting in your server parameter file： PGA_AGGREGATE_TARGET = 800M
SORT_AREA_SIZE = 100M
HASH_AREA_SIZE = 100M
BITMAP_MERGE_AREA_SIZE = 100M
CREATE_BITMAP_AREA_SIZE = 100M
Which statement is true？（）

You have included the following parameter settings in your SPFILE：
SGA_MAX_SIZE=8G
SGA_TARGET=6G
DB_CACHE_SIZE=2G
SHARED_POOL_SIZE=1G
LOG_BUFFER=64M
DB_KEEP_CACHE_SIZE=960M
Which statement is true if you modify the SGA_TARGET initialization parameter？（）