set pages 1000 lines 132

col full_path form a90
col mb form   999,990.0
col fnum form a5
SELECT CONCAT('+'||gname, SYS_CONNECT_BY_PATH(aname,'/')) full_path, 
       TO_CHAR(greatest(created,changed),'DD_MM_YYYY-HH24:MI:SS') modif ,
       BYTES/1024/1024 MB,
       decode(ADIR,'Y',null,file_number) fnum
FROM
	(SELECT g.name gname, a.parent_index pindex, a.name aname,
		a.reference_index rindex, a.ALIAS_DIRECTORY adir, 
		f.creation_date created, f.modification_date changed,
		f.bytes, a.file_number
	FROM v$asm_alias a, v$asm_diskgroup g, v$asm_file f
	WHERE a.group_number = f.group_number (+)
	AND   a.file_number = f.file_number (+)
	AND   a.group_number = g.group_number
	AND   g.name = '&dgname')
START WITH (MOD(pindex, POWER(2, 24))) = 0
CONNECT BY PRIOR rindex = pindex
order by 1;