Oracle教程 2023-02-24

Oracle 视图 V$IOSTAT_CONSUMER_GROUP 官方解释，作用，如何使用详细说明

Oracle 视图V$IOSTAT_CONSUMER_GROUP主要用于收集具有不同所有者的常见磁盘I/O率的统计信息，并将该信息汇总为一个客户结算组。可以使用该视图跟踪文件的当前I/O活动，并动态优化资源。

该视图通常具有以下列：

IOSTAT_CONSUMER_GROUP: 客户消费组的名称。

OWNER_ID: 文件所有者标识符。

OWNER_NAME: 文件所有者名称。

READ_TIME: 此消费组中所有文件的总读取时间。

WRITE_TIME: 此消费组中所有文件的总写入时间。

TOTAL_RATE: 此消费组中所有文件的总I/O速率。

使用此视图，可以按照所有者来查询活动磁盘I/O统计信息，并以不同的消费者组来分组显示。

V$IOSTAT_CONSUMER_GROUP displays disk I/O statistics for consumer groups.

If the resource manager is enabled, then I/O statistics for all consumer groups that are part of the currently enabled resource plan are captured.

Column	Datatype	Description
`CONSUMER_GROUP_ID`	`NUMBER`	Consumer group ID
`SMALL_READ_MEGABYTES`	`NUMBER`	Number of single block megabytes read
`SMALL_WRITE_MEGABYTES`	`NUMBER`	Number of single block megabytes written
`LARGE_READ_MEGABYTES`	`NUMBER`	Number of multiblock megabytes read
`LARGE_WRITE_MEGABYTES`	`NUMBER`	Number of multiblock megabytes written
`SMALL_READ_REQS`	`NUMBER`	Number of single block read requests
`SMALL_WRITE_REQS`	`NUMBER`	Number of single block write requests
`LARGE_READ_REQS`	`NUMBER`	Number of multiblock read requests
`LARGE_WRITE_REQS`	`NUMBER`	Number of multiblock write requests
`NUMBER_OF_WAITS`	`NUMBER`	Number of I/O waits by consumer group
`WAIT_TIME`	`NUMBER`	Total wait time (in milliseconds)
`CON_ID`	`NUMBER`	The ID of the container to which the data pertains. Possible values include: `0`: This value is used for rows containing data that pertain to the entire CDB. This value is also used for rows in non-CDBs. `1`: This value is used for rows containing data that pertain to only the root n: Where n is the applicable container ID for the rows containing data

分享到：