ORACLE11GR2查看下在ASM方式管理下文件分布情况
目的：想看下在ASM方式管理下，磁盘文件的分布情况，在库中增加了个文件
SQL> alter tablespace xiaobi add datafile '+oradata/xiaobi002.dbf' size 50M;
Tablespace altered.
SQL> select file_id,tablespace_name,file_name from dba_data_files;
FILE_ID TABLESPACE_NAME FILE_NAME
---------- ------------------------------ ------------------------------------------------------------
4 USERS +ORADATA/orcl/datafile/users.259.845158551
3 UNDOTBS1 +ORADATA/orcl/datafile/undotbs1.258.845158551
2 SYSAUX +ORADATA/orcl/datafile/sysaux.257.845158551
1 SYSTEM +ORADATA/orcl/datafile/system.256.845158551
5 EXAMPLE +ORADATA/orcl/datafile/example.265.845158643
6 XIAOBI +ORADATA/orcl/datafile/xiaobi.267.845197787
7 XIAOBI +ORADATA/xiaobi001.dbf
8 XIAOBI +ORADATA/xiaobi002.dbf
8 rows selected.
SQL> select NAME,GROUP_NUMBER,FILE_NUMBER,FILE_INCARNATION,ALIAS_INCARNATION,ALIAS_DIRECTORY,SYSTEM_CREATED from v$asm_alias where name like 'xiaobi%';
NAME GROUP_NUMBER FILE_NUMBER FILE_INCARNATION ALIAS_INCARNATION A S
---------------------------------------------------------------------- ------------ ----------- ---------------- ----------------- - -
xiaobi001.dbf 2 268 845200729 1 N N
xiaobi002.dbf 2 269 845285587 1 N N
SQL> select NAME,GROUP_NUMBER,FILE_NUMBER,FILE_INCARNATION,ALIAS_INCARNATION,ALIAS_DIRECTORY,SYSTEM_CREATED from v$asm_alias where name like 'XIAOBI%';
NAME GROUP_NUMBER FILE_NUMBER FILE_INCARNATION ALIAS_INCARNATION A S
---------------------------------------------------------------------- ------------ ----------- ---------------- ----------------- - -
XIAOBI.267.845197787 2 267 845197787 1 N Y
XIAOBI.268.845200729 2 268 845200729 3 N Y
XIAOBI.269.845285587 2 269 845285587 3 N Y
SQL> select GROUP_KFFXP,NUMBER_KFFXP, PXN_KFFXP,XNUM_KFFXP,LXN_KFFXP,DISK_KFFXP,AU_KFFXP from x$kffxp where NUMBER_KFFXP=269;
no rows selected
X$KFFXP视图却没显示任何文件分布在磁盘的情况 是为何？请指点
页:
[1]