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;