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”


数据运维技术 » Oracle 视图 V$ASM_DISKGROUP_STAT 官方解释,作用,如何使用详细说明