在数据库实例上检查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结果就不正确。
来自 “ ITPUB博客 ” ,链接:https://blog.itpub.net/4227/viewspace-680416/ ,如需转载,请注明出处,否则将追究法律责任。