set lines 300set pages 1000col gname form a10col dbname form a10col file_type form a18 SELECTgname as “DG NAME”,dbname,file_type,round(SUM(space)/1024/1024) mb,round(SUM(space)/1024/1024/1024) gb,COUNT(*) “#FILES”FROM(SELECTgname,regexp_substr(full_alias_path, ‘[[:alnum:]_]*’,1,4) dbname,file_type,space,aname,system_created,alias_directoryFROM(SELECTconcat(‘+’||gname, sys_connect_by_path(aname, ‘/’)) full_alias_path,system_created,alias_directory,file_type,space,level,gname,anameFROM(SELECTb.name gname,a.parent_index pindex,a.name aname,a.reference_index rindex ,a.system_created,a.alias_directory,c.type file_type,c.spaceFROMv$asm_alias a,v$asm_diskgroup b,v$asm_file cWHEREa.group_number = b.group_numberAND a.group_number = c.group_number(+)AND a.file_number = c.file_number(+)AND a.file_incarnation = c.incarnation(+) ) START WITH (mod(pindex, power(2, 24))) = 0AND rindex […]
Category: Scripts
Oracle scripts articles