ASM disk operations   ..

+ASM disk operations

set linesize 200
select * from v$asm_operation;

select operation, state, power, est_rate, est_minutes, round((sofar/est_work)*100,2) pct_comp from v$asm_operation;

col oper     for a5
col name     for a20
col power    for 9999
col actual   for 9999
col est_min  for 9999
col power    for 9999
col est_rate for 99999

col sofar    for 9999999

select dg.name ,do.operation oper ,do.state ,do.power,do.actual ,do.sofar ,do.est_rate ,do.est_minutes est_min from v$asm_operation do , v$asm_diskgroup dg 
where 1=1 
and dg.group_number = do.group_number
order by 2,1 ;


select group_number, name, total_mb, free_mb from v$asm_disk_stat;

ps -efa | grep asm_arb