oracle磁盘组使用率高,html监控ASM磁盘组使用率

CREATE OR REPLACE procedure SYSTEM.sp_asm_check as

x number;

v_html varchar2(30000);

begin

select min(round((free_mb/total_mb)*100)) into x  from gv$asm_diskgroup;

if x<30 then

v_html:='xmlns="">';

v_html:=v_html||'

';

v_html:=v_html||'

';

v_html:=v_html||'

v_html:=v_html||'

';

v_html:=v_html||'

nametotal_Gbfree_Gbcanuse';

v_html:=v_html||'

';

for mm in ( select name,round(total_mb/1024) total_Gb,round(free_mb/1024) free_Gb,round((free_mb/total_mb)*100) canuse from gv$asm_diskgroup)  loop

v_html:=v_html||'

';

v_html:=v_html||'

'||mm.name||''||mm.total_Gb||''||mm.free_Gb||''||mm.canuse||'%'||'';

v_html:=v_html||'

';

end loop;

v_html:=v_html||'

';

v_html:=v_html||'';

v_html:=v_html||'