Automatic Storage Management

ASM Disk Stats

set lines 200
col unbalanced for a10
col name for a7
col "allo size" for 9,999,999
select
  name
, group_number
, block_size
, allocation_unit_size "allo size"
, state,total_mb
, free_mb
, usable_file_mb
, offline_disks
, unbalanced
from v$asm_diskgroup_stat;