Visualizing Disk Groups in Oracle ASM with SQL

Note: A group number of zero his indicates that a disk is available but hasn't yet been assigned to a disk group.

SQL Code

 1set lines 100
 2col name format a10
 3col path format a30
 4select	name
 5,	group_number
 6,	disk_number
 7,	mount_status
 8,	state
 9,	path
10from …