在数据库实例中查询v$asm相关视图的问题

最新推荐文章于 2021-09-09 19:13:10 发布

转载最新推荐文章于 2021-09-09 19:13:10 发布 · 633 阅读

文章标签：

#vasm_disk #vasm_diskgroup #rdbms #instance

Oracle DB 专栏收录该内容

772 篇文章

订阅专栏

本文解释了在Oracle Automatic Storage Management (ASM)实例与数据库实例中，V$ASM_DISK与V$ASM_DISKGROUP视图显示信息的差异。指出ASM视图需从ASM实例监控，以减少消息传递流量，并概述了两种情况下视图的具体区别。

摘自:

v$asm_disk free_mb Is Different In Database Instance (文档 ID 372274.1)

SOLUTION

ASM views must be monitored from +ASM instance, as the information is not updated
in database instance to reduce messaging traffic.

Please also see that there are also other limitations when querying
asm views from database instance.

V$ASM_DISK
In an Automatic Storage Management instance, V$ASM_DISK displays one row for
every disk discovered by the Automatic Storage Management instance,
including disks which are not part of any disk group. In a database instance,
V$ASM_DISK only displays rows for disks in disk groups in use by the database
instance.

V$ASM_DISKGROUP
The GROUP_NUMBER, TOTAL_MB, and FREE_MB columns are only meaningful
if the disk group is mounted by the instance. Otherwise, their values
will be 0.