Saturday, September 29, 2012
Find files that we have in Diskgroup in Oracle ASM
How to find the files that we have in Diskgroup in Oracle ASM -Source: Oracle Metalink
--------------------------------------------------------------------------------
select * from (SELECT level, dir, sys, substr(lpad(' ',2*level,' ')||CONCAT('+'||gname,
SYS_CONNECT_BY_PATH(aname,'/')),1,60) full_path
FROM ( SELECT g.name gname, a.parent_index pindex, a.name aname,
a.reference_index rindex, a.ALIAS_DIRECTORY dir, a.SYSTEM_CREATED sys
FROM v$asm_alias a, v$asm_diskgroup g
WHERE a.group_number = g.group_number)
START WITH (MOD(pindex, POWER(2, 24))) = 0
CONNECT BY PRIOR rindex = pindex
ORDER BY rtrim(ltrim(full_path))desc, level asc)
where upper(full_path) like '%<>%'
Subscribe to:
Post Comments (Atom)
No comments:
Post a Comment