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.
Increase the number of checkpoint processes.
B.
Define the POWER option while adding or removing the disks.
C.
Increase the number of ARB processes by setting up a higher value for ASM_POWER_LIMIT.
D.
Increase the number of DBWR processes by setting up a higher value for DB_WRITER_PROCSSES.
E.
Increase the number of slave database writer processes by setting up a higher value for DBWR_IO_SLAVES.
Explanation:
If the POWER clause is not specified in an ALTER DISKGROUP command, or when rebalance is implicitly invoked by adding or dropping a disk, the rebalance power defaults to the value of the ASM_POWER_LIMIT initialization parameter. You can adjust this parameter dynamically. The higher the limit, the faster a rebalance operation may complete. Lower values cause rebalancing to take longer, but consume fewer processing and I/O resources. This leaves these resources available for other applications, such as the database. The default value of 1 minimizes disruption to other applications. The appropriate value is dependent upon your hardware configuration as well as performance and availability requirements.REF: Oracle 10g Administrator Guide 12-9
