select
group_number, -- GROUP_NUMBER NUMBER
operation, -- OPERATION CHAR(5)
state, -- STATE VARCHAR2(4)
power, -- POWER NUMBER
actual, -- ACTUAL NUMBER
sofar, -- SOFAR NUMBER
est_work, -- EST_WORK NUMBER
est_rate, -- EST_RATE NUMBER
est_minutes, -- EST_MINUTES NUMBER
error_code -- ERROR_CODE VARCHAR2(44)
from
gv$asm_operation
where
inst_id = USERENV('Instance')