Streams Pool (94)

最新推荐文章于 2025-09-09 18:12:37 发布

转载最新推荐文章于 2025-09-09 18:12:37 发布 · 409 阅读

文章标签：

#数据库

本文介绍了如何在Oracle数据库中配置Streams内存池。主要通过设置STREAMS_POOL_SIZE初始化参数来指定内存池大小。若设置了SGA_TARGET，则内存从SGA的全局池分配；否则，从缓冲区缓存中分配，大小为共享池大小的10%。

In a single database, you can specify that Streams memory be allocated from a pool in
the SGA called the Streams pool. To configure the Streams pool, specify the size of the
pool in bytes using the STREAMS_POOL_SIZE initialization parameter. If a Streams
pool is not defined, then one is created automatically when Streams is first used.
If SGA_TARGET is set, then the SGA memory for the Streams pool comes from the
global pool of SGA. If SGA_TARGET is not set, then SGA for the Streams pool is
transferred from the buffer cache. This transfer takes place only after the first use of
Streams. The amount transferred is 10% of the shared pool size.

Streams Pool
1. 通过STREAMS_POOL_SIZE参数指定大小
2. 如果设置了SGA_TARGET, Streams pool从global pool中分配, 否则从buffer cache中调出, 大小为shared
pool size的10%

[@more@]

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/10599713/viewspace-978512/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/10599713/viewspace-978512/