/* -- Verifica apenas os DGs do ASM -- */
SET lines 180
SET pages 1000
col COMPATIBILITY for a15
col DATABASE_COMPATIBILITY for a15

SELECT
  group_number,
  name,
  total_mb,
  free_mb,
  round(((total_mb - free_mb) * 100 / total_mb), 2) AS PERC,
  state,
  COMPATIBILITY,
  DATABASE_COMPATIBILITY 
FROM
  v$asm_diskgroup 
ORDER BY
  group_number;