131.Exhibit:
View the Exhibit to examine the parameter values. You are planning to set the value for the
MEMORY_TARGET parameter of your database instance.
What value would you assign?
A. 1440 MB
B. 90 MB
C. 362 MB
D. 272 MB
View the Exhibit to examine the parameter values. You are planning to set the value for the
MEMORY_TARGET parameter of your database instance.
What value would you assign?
A. 1440 MB
B. 90 MB
C. 362 MB
D. 272 MB
Answer: C
应大于sga与pga之和
SQL> show parameter target
NAME TYPE VALUE
------------------------------------ ----------- -------------
archive_lag_target integer 0
db_flashback_retention_target integer 1440
fast_start_io_target integer 0
fast_start_mttr_target integer 0
memory_max_target big integer 704M
memory_target big integer 704M
parallel_servers_target integer 32
pga_aggregate_target big integer 300M
sga_target big integer 400M
SQL> alter system set memory_target=600m;
alter system set memory_target=600m
*
第 1 行出现错误:
ORA-02097: 无法修改参数, 因为指定的值无效
ORA-00838: 指定的 MEMORY_TARGET 的值太小, 至少应为 700M