SET lines 200 pages 200
COL path format a30
COL name format a20
COL state format a10
COL mount_status format a10
SET feedback off

SELECT
  GROUP_NUMBER,
  NAME,
  TOTAL_MB,
  FREE_MB,
  STATE,
  OFFLINE_DISKS,
  round((FREE_MB / TOTAL_MB)*100, 1) " % FREE" 
FROM
  v$ASM_diskgroup;
------------------------------------------------------------------
SET  pagesize 5555 
SET  linesize 500 
  SELECT
    name,
    total_mb - free_mb "OCUP_MB",
    free_mb,
    total_mb,
    round((total_mb - free_mb)*100 / TOTAL_MB, 2) "PER_OCUP",
    round(FREE_MB*100 / TOTAL_MB, 2) "PER_FREE" 
  FROM
    v$ASM_diskgroup;