Skip Headers

Oracle® Database Reference
10g Release 1 (10.1)

Part Number B10755-01
Go to Documentation Home
Go to Book List
Book List
Go to Table of Contents
Go to Index
Go to Master Index
Master Index
Go to Feedback page

Go to previous page
Go to next page
View PDF


In an Automatic Storage Management instance, V$ASM_OPERATION displays one row for every active Automatic Storage Management long running operation executing in the Automatic Storage Management instance. In a database instance, V$ASM_OPERATION displays no rows.

Column Datatype Description
GROUP_NUMBER NUMBER Disk group number (primary key). This is the foreign key to the V$ASM_DISKGROUP view.
OPERATION VARCHAR2(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