Oracle教程 2023-02-24

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

Oracle视图V$STREAMS_POOL_STATISTICS提供了Streams处理池的各种信息，可提供存储进程之间每每秒的流行率，以及在每次重复之前收到的消息数目，等等。

使用方法：

1.查询为某一存储进程处理的流量统计：
SELECT * FROM V$STREAMS_POOL_STATISTICS WHERE PROCESS=’PROC_NUM’;

2.查询某一时间段内的所有流量统计：
SELECT * FROM V$STREAMS_POOL_STATISTICS WHERE TIME_ARRIVED > TO_DATE(’20XX-XX-XX’, ‘YYYY-MM-DD’) AND TIME_ARRIVED

V$STREAMS_POOL_STATISTICS displays information about the current Streams pool usage percentage.

Column	Datatype	Description
`TOTAL_MEMORY_ALLOCATED`	`NUMBER`	Total memory allocated to the Streams pool (in bytes). It should always be less than the current size of the Streams pool. You can get the percentage of the Streams pool used by dividing `TOTAL_MEMORY_ALLOCATED` by `CURRENT_SIZE`.
`CURRENT_SIZE`	`NUMBER`	Current size of the Streams pool (in bytes)
`SGA_TARGET_VALUE`	`NUMBER`	Value of `SGA_TARGET`. Used to determine whether or not streams pool automatic tuning is enabled. This should be set even if `MEMORY_TARGET` is set and `SGA_TARGET` is not set.
`SHRINK_PHASE`	`NUMBER`	This only pertains to the Streams pool in an automatic tuning environment (`SGA_TARGET` and `MEMORY_TARGET` set). In this case, this shows whether or not the Streams pool is being asked to shrink. During the shrink phase, enqueues are blocked, flow control is enabled for all components, and cached memory is returned to the SGA.
`ADVICE_DISABLED`	`NUMBER`	This determines whether or not Streams pool advice in `V$STREAMS_POOL_ADVICE` as well as all statistics gathering related to auto-tuning the Streams pool have been disabled.
`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

分享到：