select name,type,total_mb,free_mb,required_mirror_free_mb,usable_file_mb
2 from v$asm_diskgroup
3* where type='NORMAL';
AME TYPE TOTAL_MB FREE_MB
------------------------------ ------ ---------- ----------
REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB
----------------------- --------------
DG8 NORMAL 576 474
0 237
DG_1 NORMAL 2048 1336
0 668
1,只适用于normal and high redundancy
2,列间关系为:
FREE_MB - REQUIRED_MIRROR_FREE_MB = 2 * USABLE_FILE_MB
Disk Group Type | Maximum File Size |
---|---|
External redundancy | 35 TB |
Normal redundancy | 5.8 TB |
High redundancy | 3.9 TB |
来自 “ ITPUB博客 ” ,链接:http://blog.itpub.net/9240380/viewspace-620656/,如需转载,请注明出处,否则将追究法律责任。
转载于:http://blog.itpub.net/9240380/viewspace-620656/