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: `REBAL` - Rebalance pending for this group. The disk group is rebalancing. Starting with Oracle Database 12c, new queries should use the `PASS` column instead of this column.
`PASS`	`VARCHAR2(9)`	Type of the operation: `REBALANCE` - Rebalance pending for this group. The disk group is rebalancing. `RESYNC` - Resync operation in progress to bring one or more Oracle ASM disks online `COMPACT` - Oracle ASM is moving user data closer together, which improves performance by reducing seek distance Starting with Oracle Database 12c, new queries should use this column instead of the `OPERATION` column.
`STATE`	`VARCHAR2(4)`	State of the operation: `WAIT` - No operations running for the group `RUN` - Operation running for the group `REAP` - Operation is being run down `DONE` - Displayed for a pass that is complete `ERRS` - Operation halted by errors
`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
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data For this view, the value is always `0`.