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
/