ITPub博客

首页 > Linux操作系统 > Linux操作系统 > 数据库实例$ASM_DISK视图的FREE_MB值不正确

数据库实例$ASM_DISK视图的FREE_MB值不正确

原创 Linux操作系统 作者:yangtingkun 时间:2010-11-26 20:56:05 0 删除 编辑

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

下一篇: 20101127 ACOUG活动
请登录后发表评论 登录
全部评论
暂无介绍

注册时间:2007-12-29

  • 博文量
    1955
  • 访问量
    10455204