本站中文解释
Oracle视图V$ASM_OPERATION用于查看ASM实例正在进行的操作以及各个操作的进度状态,使用该视图可以查看ASM状态,支持异步I/O、数据拷贝等等操作,包括更新状态、完成状态等等。
使用方法:
SELECT * FROM V$ASM_OPERATION;
该语句可以查询ASM当前正在进行中的操作类型以及操作的当前进度状态。
官方英文解释
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 |
---|---|---|
|
|
Disk group number (primary key). This is the foreign key to the |
|
|
Type of the operation:
Starting with Oracle Database 12c, new queries should use the |
|
|
Type of the operation:
Starting with Oracle Database 12c, new queries should use this column instead of the |
|
|
State of the operation:
Estimates are computed in parallel in the background while the work is being executed. Thus, the transition from the |
|
|
Power requested for the operation as specified by the ASM_POWER_LIMIT initialization parameter or command syntax. Or, power requested for the operation as specified by the power option of the scrubbing SQL syntax. |
|
|
Power allocated to the operation |
|
|
Number of Allocation Units that are being moved per minute by the operation. Or, the number of Allocation Units that have been scrubbed so far. |
|
|
Estimated number of Allocation Units that have to be moved by the operation. Or, the estimated number of Allocation Units that have to be scrubbed by the scrubbing operation. |
|
|
Estimated number of Allocation Units that are being moved per minute by the operation |
|
|
Estimated amount of time (in minutes) that the remainder of the operation is expected to take |
|
|
Oracle external error code; NULL if no error |
|
|
The ID of the container to which the data pertains. Possible values include:
For this view, the value is always |
See Also:
Oracle Automatic Storage
Management Administrator’s Guide for additional information about using views to display Oracle ASM information