1、查看Diskgroup的磁盘使用情况:
2、查看磁盘的Extent数量:
GROUP_KFFXP为磁盘组号
3、查看数据文件在磁盘上的分布情况:
NUMBER_KFFXP为数据文件的编号,可以从数据文件名中得到
- SQL> SELECT NAME, TOTAL_MB, FREE_MB FROM V$ASM_DISK WHERE GROUP_NUMBER=1;
-
- NAME TOTAL_MB FREE_MB
- ------------------------------ ---------- ----------
- ASMDISK1 2097149 2066153
- ASMDISK2 2097149 2066147
- ASMDISK3 1717762 1692373
- ASMDISK4 1717762 1692371
2、查看磁盘的Extent数量:
- SQL> SELECT COUNT(PXN_KFFXP), DISK_KFFXP, GROUP_KFFXP FROM X$KFFXP WHERE
- 2 GROUP_KFFXP=1 GROUP BY DISK_KFFXP, GROUP_KFFXP ORDER BY GROUP_KFFXP,
- 3 DISK_KFFXP;
-
- COUNT(PXN_KFFXP) DISK_KFFXP GROUP_KFFXP
- ---------------- ---------- -----------
- 30841 0 1
- 30846 1 1
- 25261 2 1
- 25260 3 1
3、查看数据文件在磁盘上的分布情况:
- SQL> SELECT DISK_KFFXP, COUNT (DISK_KFFXP) EXTENTS FROM X$KFFXP WHERE
- 2 GROUP_KFFXP=1 AND NUMBER_KFFXP=322 AND DISK_KFFXP <> 65534 GROUP BY
- 3 NUMBER_KFFXP,DISK_KFFXP;
-
- DISK_KFFXP EXTENTS
- ---------- ----------
- 0 6755
- 1 6757
- 2 5533
- 3 5533
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/13885898/viewspace-2137078/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/13885898/viewspace-2137078/