ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 043-172

043-172

原创 Linux操作系统 作者:jbymy2000 时间:2012-03-10 10:45:11 0 删除 编辑
172. You enabled Automatic Shared Memory Management. The initializati
on parameters are set as shown below:
SGA_TARGET = 10GB
SGA_MAX_SIZE = 14GB
STREAMS_POOL_SIZE = 1GB
SHARED_POOL_SIZE = 3GB
Which two statements are correct in this scenario? (Choose two.)
A. A total of 14 GB memory will be allocated to the automatically tun
ed memory components.
B. Reducing the value for SGA_TARGET to 9 GB will automatically decre
ase the memory allocated to shared pool from 3 GB to 2 GB.
C. The value for SGA_TARGET can be increased up to a maximum of 14 GB
D. A maximum of 3 GB can be allocated to shared pool.
E. Increasing the value for SGA_TARGET to 12 GB will automatically in
crease the memory allocated to autotuned parameters.
F. Increasing the value for SGA_TARGET will automatically increase th
e memory allocated for STREAMS_POOL_SIZE.
Answer: C,E
SGA_TARGET 表明sga 初始化的大小10G,SGA_MAX_SIZE 表明当SGA 的各个组件不够用
时,SGA 最多能扩展到14G,下面两个说明这两个组件会被分配就这么大,剩下的6G 空间将
被分配到其它组件。但是,如果如果SGA 不够用 扩展到14G SHARED_POOL_SIZE 和
STREAMS_POOL_SIZE 会增加吗?按照题意,是不能够增加的,怀疑
流池:由 Oracle Streams 使用
A. A maximum of 3 GB can be allocated to shared pool.
----共享池至少分配3G,而不是最多分配3G
B. The value for SGA_TARGET can be increased up to a maximum of 14 GB.
----SGA_TARGET 最大可以到SGA_MAX_SIZE 但不会超过
C. A total of 14 GB memory will be allocated to the automatically tuned memory
components.
----所有自动调整的组件可以分配的内存是在10G 到14G 之间,如果内存需要超过了10G,
那就出现OVER ALLOCATE,也就说明SGA_TARGET 设置的过小,需要适当加大SGA_TARGET 才
D. Increasing the value for SGA_TARGET will automatically increase the memory
allocated for STREAMS_POOL_SIZE.
-----增加SGA_TARGET 应该会自动调整相关组件的大小,可能会出现增大
STREAMS_POOL_SIZE,如果一开始STREAMS_POOL_SIZE 就已经满足了要求呢,就不会再增加
了吧
E. Increasing the value for SGA_TARGET to 12 GB will automatically increase the
memory allocated to autotuned parameters.
---加大SGA_TARGET 应该会自动加大相关组件的大小,如果组件原来的值不能完全满足需求
的话
F. Reducing the value for SGA_TARGET to 9 GB will automatically decrease the memory
allocated to shared pool from 3 GB to 2 GB.
---SHARED_POOL_SIZE 设置了这个值,就限制了最小分配给共享池的大小 ,不能低于这个
值。所以应该不会出现这个情况

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

上一篇: 043-171
下一篇: 043-173
请登录后发表评论 登录
全部评论

注册时间:2012-01-10

  • 博文量
    416
  • 访问量
    204364