ITPub博客

首页 > 数据库 > Oracle > Oracle 11G OCP 1Z0-052 51

Oracle 11G OCP 1Z0-052 51

原创 Oracle 作者:LuiseDalian 时间:2014-06-11 06:36:47 0 删除 编辑
(51)In a system, large online transaction processing (OLTP) jobs run during the daytime that require a large database buffer cache.

In the night, the system supports batch jobs that require a higher value to be set for the large pool.

You must simultaneously configure the memory components to accommodate the peak requirement.

What would you do to automate this configuration for the memory components with change in mode of working?

A.Set the SGA_TARGET initialization parameter to zero.

B.Set the PRE_PAGE_SGA initialization parameter to TRUE.

C.Set the MEMORY_MAX_TARGET initialization parameter to zero.

D.Set the SGA_TARGET initialization parameter to a nonzero value.

答案:(D)

解析:

这里需要Oracle根据需要自动地根据需要来调整内存组件的大小,即SGA需要自动进行管理。

B(X). PRE_PAGE_SGA决定Oracle在实例启动时是否将整个SGA读入内存。

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

请登录后发表评论 登录
全部评论

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    6043010