COL state for a10
COL name for a10
COL failgroup for a10
COL label for a15
COL path for a15

SET lines 200
SET pages 200

SELECT 
	GROUP_NUMBER, 
	DISK_NUMBER, 
	MOUNT_STATUS, 
	MODE_STATUS, 
	STATE, 
	REDUNDANCY, 
	TOTAL_MB, 
	FREE_MB, 
	NAME, 
	FAILGROUP, 
	LABEL, 
	PATH, 
	to_char(MOUNT_DATE,'DD-MM-YYYY HH24/:MI/:SS') 
FROM 
	v$ASM_disk
/

hostgator