540.Which of the following ALTER DISKGROUP commands does not use V$ASM_OPERATION to
record the status of the operation?
A. ADD DIRECTORY
B. DROP DISK
C. RESIZE DISK
D. REBALANCE
E. ADD FAILGROUP
Answer: A
答案解析:
参考:http://blog.csdn.net/rlhua/article/details/12972983
V$ASM_OPERATION
In an Oracle Automatic Storage Management (Oracle ASM) instance, V$ASM_OPERATION
displays one row for every active Oracle ASM long running operation executing in the Oracle ASM instance.
Column | Datatype | Description |
---|---|---|
GROUP_NUMBER | NUMBER | Disk group number (primary key). This is the foreign key to the V$ASM_DISKGROUP view. |
OPERATION | CHAR(5) | Type of the operation:
|
STATE | VARCHAR2(4) | State of the operation:
|
POWER | NUMBER | Power requested for the operation as specified by the ASM_POWER_LIMIT initialization parameter or command syntax |
ACTUAL | NUMBER | Power allocated to the operation |
SOFAR | NUMBER | Number of Allocation Units that have been moved so far by the operation |
EST_WORK | NUMBER | Estimated number of Allocation Units that have to be moved by the operation |
EST_RATE | NUMBER | Estimated number of Allocation Units that are being moved per minute by the operation |
EST_MINUTES | NUMBER | Estimated amount of time (in minutes) that the remainder of the operation is expected to take |
ERROR_CODE | VARCHAR2(44) | Oracle external error code; NULL if no error |
V$ASM_OPERATION是记录当前磁盘的操作信息。
B,C,D,E都会涉及到磁盘的操作,只有A是涉及目录的操作,所以选A