USABLE_FILE_MB的值代表了总的可用来存储数据的空间,它的值依赖磁盘组的大小,磁盘组的冗余度和REQUIRED_MIRROR_FREE_MB的值,USABLE_FILE_MB的值的计算方法如下: (Total_MB/FG个数/冗余度)* 坏掉最大磁盘组剩余的个数 例如: State Type Rebal Sector Block AU Total_MB Free_MB Req_mir_free_MB Usable_...
SQL> Col name format a15 SQL> select GROUP_NUMBER,NAME,STATE,TYPE,TOTAL_MB,FREE_MB,REQUIRED_MIRROR_FREE_MB,USABLE_FILE_MB from v$asm_diskgroup; GROUP_NUMBER NAME STATE TYPE TOTAL_MB FREE_MB REQUIRED_MIRROR_FREE_MB USABLE_FILE_MB --- --- --- --- --- --- --- --- 1 DATA MOU...