Search This Blog

Total Pageviews

Sunday 12 November 2017

ASM disk operations

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;

Oracle DBA

anuj blog Archive