- 最后登录
- 2016-8-29
- 在线时间
- 35 小时
- 威望
- 0
- 金钱
- 142
- 注册时间
- 2013-8-27
- 阅读权限
- 10
- 帖子
- 28
- 精华
- 0
- 积分
- 0
- UID
- 1204
|
1#
发表于 2014-4-19 13:35:25
|
查看: 1903 |
回复: 0
目的:想看下在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视图却没显示任何文件分布在磁盘的情况 是为何?请指点 |
|