OCP 1Z0 053 131

来源：互联网发布：上海java培训机构大全编辑：程序博客网时间：2024/05/10 12:02

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

Answer: C

应大于sga与pga之和

SQL> show parameter targetNAME                                 TYPE        VALUE------------------------------------ ----------- -------------archive_lag_target                   integer     0db_flashback_retention_target        integer     1440fast_start_io_target                 integer     0fast_start_mttr_target               integer     0memory_max_target                    big integer 704Mmemory_target                        big integer 704Mparallel_servers_target              integer     32pga_aggregate_target                 big integer 300Msga_target                           big integer 400MSQL> alter system set memory_target=600m;alter system set memory_target=600m*第 1 行出现错误:ORA-02097: 无法修改参数, 因为指定的值无效ORA-00838: 指定的 MEMORY_TARGET 的值太小, 至少应为 700M

0 0