ITPub博客

首页 > 数据库 > Oracle > Oracle OCP 1Z0 053 Q283(Automatic Memory Management)

Oracle OCP 1Z0 053 Q283(Automatic Memory Management)

原创 Oracle 作者:abstractcyj 时间:2016-04-04 14:36:44 0 删除 编辑
283.You set the following parameters in the parameter file and restarted the database:
MEMORY_MAX_TARGET=0
MEMORY_TARGET=500M PGA_AGGREGATE_TARGET=90M SGA_TARGET=270M
Which two statements are true regarding these parameters after the database instance is restarted?
(Choose two.)
A. The MEMORY_MAX_TARGET parameter is automatically set to 500 MB.
B. The value of the MEMORY_MAX_TARGET parameter remains zero till it is changed manually.
C. The PGA_AGGREGATE_TARGET and SGA_TARGET parameters are automatically set to zero.
D. The lower bounds of PGA_AGGREGATE_TARGET and SGA_TARGET parameters are set to 90 MB
and 270 MB, respectively.
Answer: AD


当设置了MEMORY_TARGET=500M, 那么MEMORY_MAX_TARGET自动被设置成500M
当启用了自动内存管理之后,再去设置 PGA_AGGREGATE_TARGET与SGA_TARGET, 这时候SGA_TARGET与PGA_AGGREGATE_TARGET的值就成了下限了。

官方文档:https://docs.oracle.com/cd/B28359_01/server.111/b28310/memory003.htm

In a text initialization parameter file, if you omit the line for MEMORY_MAX_TARGET and include a value for MEMORY_TARGET, the database automatically sets MEMORY_MAX_TARGETto the value of MEMORY_TARGET. If you omit the line for MEMORY_TARGET and include a value for MEMORY_MAX_TARGET, the MEMORY_TARGET parameter defaults to zero. After startup, you can then dynamically change MEMORY_TARGET to a nonzero value, provided that it does not exceed the value of MEMORY_MAX_TARGET.

The preceding steps instruct you to set 
SGA_TARGET and PGA_AGGREGATE_TARGET to zero so that the sizes of the SGA and instance PGA are tuned up and down as required, without restrictions. You can omit the statements that set these parameter values to zero and leave either or both of the values as positive numbers. In this case, the values act as minimum values for the sizes of the SGA or instance PGA.

来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/8520577/viewspace-2075001/,如需转载,请注明出处,否则将追究法律责任。

请登录后发表评论 登录
全部评论
曾从事java方向开发多年。近年已经转入数据库方向。主要擅长SQL优化,Oracle数据库问题诊断,Oracle备份与恢复等。服务于医药物流,医院等行业

注册时间:2010-01-26

  • 博文量
    555
  • 访问量
    836935