--место на ASM
SELECT  g.name                          "Group Name",
        round(g.total_mb/1024,2)    "Total Raw Gb",
        round((g.total_mb/2)/1024,2)           "Total Usable Gb",
        round(((g.free_mb - (g.required_mirror_free_mb))/2)/1024,2) Free_Gb,
        round((g.HOT_USED_MB + g.COLD_USED_MB)/2) Used_MB,
        g.OFFLINE_DISKS                  "Number Offline Disk",
        count(*)                         "DiskCnt"
FROM v$asm_disk d, v$asm_diskgroup g
WHERE d.group_number = g.group_number and
D.GROUP_NUMBER <> 0 and
d.mount_status = 'CACHED' and 
g.name <> 'DBFS_DG'
GROUP BY g.group_number, g.name, 
        g.state, g.type, 
        g.allocation_unit_size, g.total_mb, 
        g.free_mb, 
        g.HOT_USED_MB, g.COLD_USED_MB,
        g.required_mirror_free_mb,
        g.OFFLINE_DISKS
ORDER BY 1; 

--Место на DATAC2
select name, total_mb, free_mb, required_mirror_free_mb, usable_file_mb ,type from v$asm_diskgroup where name='DATAC2';