GV$ASM_OPERATION definition in Oracle Database 10.2 / www.oracledba.ru
GV$ASM_OPERATION
select
inst_id, -- INST_ID NUMBER
number_kfgmg, -- GROUP_NUMBER NUMBER
decode -- OPERATION VARCHAR2(5)
(bitand (op_kfgmg, 64), 64, 'EXPEL', decode (bitand (op_kfgmg, 32), 32, 'RFRSH', decode (bitand (op_kfgmg, 16), 16, 'ACD', decode (bitand (op_kfgmg, 8), 8, 'DSCV', decode (bitand (op_kfgmg, 4), 4, 'SYNC', decode (bitand (op_kfgmg, 2), 2, 'COD', decode (bitand (op_kfgmg, 1), 1, 'REBAL', 'NONE'))))))),
decode -- STATE VARCHAR2(4)
(state_kfgmg, 1, 'WAIT', 2, 'RUN', 3, 'REAP', 4, 'WAIT', 5, 'HALT', 6, 'ERRS'),
power_kfgmg, -- POWER NUMBER
actual_kfgmg, -- ACTUAL NUMBER
sofar_kfgmg, -- SOFAR NUMBER
work_kfgmg, -- EST_WORK NUMBER
rate_kfgmg, -- EST_RATE NUMBER
time_kfgmg -- EST_MINUTES NUMBER
from
x$kfgmg