7.69 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 |
---|---|---|
|
|
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