ITPub博客

首页 > 数据库 > Oracle > Oracle 11G OCP 1Z0-053 74

Oracle 11G OCP 1Z0-053 74

原创 Oracle 作者:LuiseDalian 时间:2014-08-16 06:58:37 0 删除 编辑
(74)Immediately after adding a new disk to or removing an existing disk from an ASM instance,

you find that the performance of the database goes down initially until the time the addition or removal process is completed,and then gradually becomes normal.

Which two activities would you perform to maintain a consistent performance of the database while adding or removing disks?(Choose two.)

A. Define the POWER option while adding or removing the disks.

B. Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.

C. Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCESSES.

D. Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES.

答案:(A、B)

解析:

《Automatic Storage Management Administrator's Guide》  4.3.7

如果在ALTER DISKGROUP语句中没有指定POWER子句, 或在添加或删除磁盘rebalance被隐式执行时,

则rebalance power默认值为ASM_POWER_LIMIT参数的值.

这个参数的值越大,则rebalance操作就越快完成.

如果rebalance power的值越小,则花的时间越长,但却消耗更少的处理和I/O资源.

ARBn进程为ASM rebalance进程

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

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

注册时间:2012-02-06

  • 博文量
    1986
  • 访问量
    6043174