Oracle 视图 V$ASM_DISKGROUP_STAT 官方解释,作用,如何使用详细说明
本站中文解释
Oracle视图V$ASM_DISKGROUP_STAT被用来报表显示ASM自身的统计数据,其中包括卷组的信息,存储的量,分配的量和状态信息。
可以在V$ASM_DISKGROUP_STAT中使用SELECT语句检索所有数据空间的大小、吞吐量性能和状态信息:
SELECT * FROM V$ASM_DISKGROUP_STAT
要检索特定卷组的统计数据,可以使用WHERE子句:
SELECT * FROM V$ASM_DISKGROUP_STAT
WHERE name=’MYDISKGROUP’
官方英文解释
V$ASM_DISKGROUP_STAT
displays performance statistics in the same way that V$ASM_DISKGROUP
does, but without performing discovery of new disk groups.
This results in a less expensive operation. However, since discovery is not performed, the output of this view does not include any data about disk groups that are new to the system.
The columns for V$ASM_DISKGROUP_STAT
are the same as those for V$ASM_DISKGROUP
.
See Also:
“V$ASM_DISKGROUP”