nerdexam
Oracle

1Z0-054 · Question #122

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…

The correct answer is C. Decrease the value for the ASM_POWER_LIMIT parameter. F. Specify the POWER clause with a lower value in an ALTER DISKGROUP statement. See the full explanation below for the reasoning.

Question

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.)

Options

  • AIncrease the number of ASMB processes.
  • BIncrease the number of DBWR_IO_SLAVES.
  • CDecrease the value for the ASM_POWER_LIMIT parameter.
  • DIncrease the value for the ASM_POWER_LIMIT parameter.
  • ESet the DISK_REPAIR_TIME disk attribute to a lower value.
  • FSpecify the POWER clause with a lower value in an ALTER DISKGROUP statement.

How the community answered

(20 responses)
  • A
    5% (1)
  • B
    15% (3)
  • C
    75% (15)
  • D
    5% (1)

Community Discussion

No community discussion yet for this question.

Full 1Z0-054 Practice