在数据库实例中查询v$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.