Oracle ASM – Commands

SQL

select * from v$asm_diskgroup order by free_mb

asmcmd

asmcmd lsdg|awk '{sub(/\//,"",$14);print}'|tr -dc '[:print:]\n'|awk -v date="$(date +"%Y-%m-%d %r")" '{print $14 "\t\t" $9"\t\t"$8"      :          " date}'|sort -k 2 -n

Leave a Reply

Your email address will not be published. Required fields are marked *