TA的每日心情 | 开心 2023-8-9 11:05 |
---|
|
GoalHow to collect the full path name of the files in ASM diskgroups
SolutionSet your ORACLE_SID to the ASM instance name.
Connect to the ASM instance:
in 10g: sqlplus / as sysdba
in 11g: sqlplus / as sysasm
Then perform the following query:
SELECT gnum, filnum, concat('+'||gname,sys_connect_by_path(aname, '/'))
FROM (SELECT g.name gname, a.parent_index pindex, a.name aname,
a.reference_index rindex, a.group_number gnum,a.file_number filnum
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;
|
|