ASM queries

  SELECT name, free_mb, total_mb, total_mb-free_mb "USED_MB", free_mb/total_mb*100 "%FREE" FROM v$asm_diskgroup; SELECT name, free_mb, total_mb, total_mb-free_mb "USED_MB" FROM v$asm_diskgroup; set lines 150 column path format a40 column name format a30 select name,path,mount_status,header_status,mode_status,state,total_mb,free_mb from v$asm_disk order by 2; Run in ASM environment(ASM_HOME) set lines 132 set pages 50 column path format a20 select name,path, group_number group_#,…