ASM file和file alias之間的對映關係！

asm沒有提供檢視直接查詢asm file和file alias之間的對映關係，我是說沒有提供可以直接查詢出來的檢視，透過下面的sql可以查詢出來

[@more@]

SQL> col file_name format a30
SQL> col alias_name format a30
SQL> SELECT f.name file_name,a.name alias_name from
2 V$ASM_ALIAS A ,
3 v$asm_alias F where f.system_created='Y' AND f.alias_directory='N'
4 and a.system_created='N'
5 and a.file_number=f.file_number and a.group_number=f.group_number;

FILE_NAME ALIAS_NAME
------------------------------ ------------------------------
Current.256.741435505 control01.ctl
Current.257.741435507 control02.ctl
Current.258.741435509 control03.ctl
group_1.259.741435511 redo01.log
group_2.260.741435517 redo02.log
group_3.261.741435525 redo03.log
SYSTEM.262.741435533 SYSTEM01.DBF
spfile.267.741436057 spfileASMDB.ora
TEST.268.741441015 TEST.DBF
group_4.269.741452517 redo04.log
group_5.270.741452653 redo05.log

已選擇11行。

SQL>