1Z0-060 · Question #74
You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes…
The correct answer is A. Increase the value of the ASM_POWER_LIMIT parameter. C. Specify the statement that adds the disk back to the disk group. The higher the power limit, the more quickly a rebalance operation can complete. Rebalancing takes longer with lower power values, but consumes fewer processing and I/O resources which are shared by other applications, such as the database. Grouping operations in a single ALTER…
Question
You administer an online transaction processing (OLTP) system whose database is stored in Automatic Storage Management (ASM) and whose disk group use normal redundancy. One of the ASM disks goes offline, and is then dropped because it was not brought online before DISK_REPAIR_TIME elapsed. When the disk is replaced and added back to the disk group, the ensuing rebalance operation is too slow. Which two recommendations should you make to speed up the rebalance operation if this type of failure happens again?
Options
- AIncrease the value of the ASM_POWER_LIMIT parameter.
- BSet the DISK_REPAIR_TIME disk attribute to a lower value.
- CSpecify the statement that adds the disk back to the disk group.
- DIncrease the number of ASMB processes.
- EIncrease the number of DBWR_IO_SLAVES in the ASM instance.
How the community answered
(60 responses)- A57% (34)
- B7% (4)
- D25% (15)
- E12% (7)
Explanation
The higher the power limit, the more quickly a rebalance operation can complete. Rebalancing takes longer with lower power values, but consumes fewer processing and I/O resources which are shared by other applications, such as the database. Grouping operations in a single ALTER DISKGROUP statement can reduce rebalancing Otherwise, derived from the values of PARALLEL_MAX_SERVERS, PARALLEL_THREADS_PER_CPU, CLUSTER_DATABASE_INSTANCES, DISPATCHERS, and Note that a value derived in this way does not take into account the requirements used for Oracle Automatic Storage Management (Oracle ASM) files
Topics
Community Discussion
No community discussion yet for this question.