Oracle 视图 V$STREAMS_POOL_ADVICE 官方解释，作用，如何使用详细说明
本站中文解释
Oracle视图V$STREAMS_POOL_ADVICE用来显示系统当前正在使用和准备使用的Streams池的建议分配大小。查看此视图中的内容可以帮助确定该Streams池需要的大小，例如内存和逻辑空间。
基本的使用方法是，为给定的Streams池执行以下查询：
SELECT * FROM V$STREAMS_POOL_ADVICE WHERE POOL_NAME=”;
这可以返回该Streams池的当前建议的分配大小，以及详细的建议，可以用来调整该池以获得最佳性能。
官方英文解释
V$STREAMS_POOL_ADVICE displays information about the estimated count of spilled or unspilled messages and the associated time spent in the spill or unspill activity for different Streams pool sizes. The sizes range from 10% to 200% of the current Streams pool size, in equal intervals. The value of the interval depends on the current size of the Streams pool.
| Column | Datatype | Description |
|---|---|---|
|
|
|
Streams pool size (in megabytes) for the estimate. The size ranges from values smaller than the current Streams pool size to values larger than the current Streams pool size, and there is a separate row for each increment. There is always an entry that shows the current Streams pool size, and there are always 20 increments. The range and the size of the increments depend on the current size of the Streams pool. |
|
|
|
Size factor with respect to the current Streams pool size |
|
|
|
Estimated count of messages spilled from the Streams pool |
|
|
|
Estimated elapsed time (in seconds) to spill |
|
|
|
Estimated count of unspills (read back from disk) |
|
|
|
Estimated elapsed time (in seconds) to unspill |
|
|
|
The ID of the container to which the data pertains. Possible values include:
|
