多項選擇題

Immediately after adding a new disk to or removing an existing disk from an Automatic Storage Management （ASM） instance， you find that the performance of the database decreases initially， until the addition or removal process is completed. Performance then gradually returns to normal levels. Which two activities could you perform to maintain a consistent performance of the database while adding or removing disks？（）

A. increase the number of checkpoint processes
B. define the POWER option while adding or removing the disks
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
E. increase the number of ASM Rebalance processes by setting up a higher value for ASM_POWER_LIMIT during the disk addition or removal

你可能感興趣的試題

單項選擇題

You work as a database administrator at Certkiller .com. In your production database there is a job， CALC_STAT， which has been scheduled to run every Friday at 5.00 p.m. CALC_STATupdates the optimizer statistics for the objects owned by the APPSschema. You want the task to be generic， thereby allowing users to modify the attributes of the task at run time without affecting the original task.Which component of Oracle Scheduler must you define to achieve this？（）

A. Window
B. Program
C. Job class
D. Window group

單項選擇題

Consider the following configuration：
/devices/D1is a member of disk group dgroupA.
/devices/D2is a member of disk group dgroupA.
/devices/D3is a member of disk group dgroupA.
You plan to add a new disk， /devices/D4，to the disk group dgroupA.
You execute the following command：
SQL> ALTER DISKGROUP dgroupA ADD DISK ’/devices/D*’；
Which task would be accomplished by the command？（）

A. The command adds the new disk， D4， to the disk group.
B. The command would result in an error because the is no disk by the name "’/devices/D*’"
C. The command will be ignored because disks starting with "D" are already members of the disk group.
D. The command would result in an error because no wildcard characters can be used in the disk name.
E. The command first detaches all the member disks starting with "D"， and the reattaches them including the new disk.

^{}