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

home |  up  |  mailbox