資料庫例項$ASM_DISK檢視的FREE_MB值不正確

在資料庫例項上檢查V$ASM_DISK檢視，發現FREE_MB欄位的值不正確。

 

 

資料庫版本為RAC 10.2.0.3：

bash-3.00$ export ORACLE_SID=+ASM1
bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on 星期四 11月 25 18:41:55 2010

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

連線到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> set pages 100 lines 120
SQL> select name, total_mb, free_mb
  2  from v$asm_diskgroup
  3  where name = 'MEMBER';

NAME                                                           TOTAL_MB    FREE_MB
------------------------------------------------------------ ---------- ----------
MEMBER                                                          1048562     425820

SQL> select name, total_mb, free_mb
  2  from v$asm_disk
  3  where name like 'MEMBER%';

NAME                                                           TOTAL_MB    FREE_MB
------------------------------------------------------------ ---------- ----------
MEMBER_0000                                                     1048562     425820

SQL> exit
從 Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options 斷開
bash-3.00$ export ORACLE_SID=tradedb1
bash-3.00$ sqlplus / as sysdba

SQL*Plus: Release 10.2.0.3.0 - Production on 星期四 11月 25 18:43:10 2010

Copyright (c) 1982, 2006, Oracle.  All Rights Reserved.

連線到:
Oracle Database 10g Enterprise Edition Release 10.2.0.3.0 - 64bit Production
With the Partitioning, Real Application Clusters, OLAP and Data Mining options

SQL> set pages 100 lines 120
SQL> select name, total_mb, free_mb
  2  from v$asm_diskgroup
  3  where name = 'MEMBER';

NAME                             TOTAL_MB    FREE_MB
------------------------------ ---------- ----------
MEMBER                            1048562     425820

SQL> select name, total_mb, free_mb
  2  from v$asm_disk
  3  where name like 'MEMBER%';

NAME                             TOTAL_MB    FREE_MB
------------------------------ ---------- ----------
MEMBER_0000                       1048562          0

可以看到從資料庫例項查詢V$ASM_DISKGROUP的結果是正確的，而查詢V$ASM_DISK結果就不正確。