column type format a14
column GB format 9990.999

select d.name, a.name, f.type, f.BYTES/1024/1024/1024 GB, f.creation_date
from v$asm_alias a, v$asm_file f, v$asm_diskgroup d
where a.group_number=f.group_number
and a.file_number=f.file_number
and a.group_number=d.group_number
and d.name like upper('&1')
order by d.name,f.type,a.name,f.creation_date;

select d.name, f.type, sum(f.BYTES)/1024/1024/1024 GB
from v$asm_alias a, v$asm_file f, v$asm_diskgroup d
where a.group_number=f.group_number
and a.file_number=f.file_number
and a.group_number=d.group_number
and d.name like upper('&1')
group by d.name,f.type,f.type
order by d.name,f.type,f.type;

