Which two recommendations would you give to lower the impact on the I/O subsystem?

You are working as a DBA in ABC Corp. You are working on online transaction processing (OLTP) system. The database uses ASM storage. One of the ASM disk goes offline because of hardware failure. When the disk is added back again after the fix, because the database is active, rebalance operations impact the I/O subsystem.
Which two recommendations would you give to lower the impact on the I/O subsystem? (Choose two.)

You are working as a DBA in ABC Corp. You are working on online transaction processing (OLTP) system. The database uses ASM storage. One of the ASM disk goes offline because of hardware failure. When the disk is added back again after the fix, because the database is active, rebalance operations impact the I/O subsystem.
Which two recommendations would you give to lower the impact on the I/O subsystem? (Choose two.)

A.
Increase the number of ASMB processes.

B.
Increase the number of DBWR_IO_SLAVES.

C.
Decrease the value for the ASM_POWER_LIMIT parameter.

D.
Increase the value for the ASM_POWER_LIMIT parameter.

E.
Set the DISK_REPAIR_TIME disk attribute to a lower value.

F.
Specify the POWER clause with a lower value in an ALTER DISKGROUP statement.



Leave a Reply 0

Your email address will not be published. Required fields are marked *