首页 > Linux操作系统 > Linux操作系统 > shared pool,large pool, Streams pool

shared pool,large pool, Streams pool

原创 Linux操作系统 作者:kevin1214 时间:2012-06-17 00:34:05 0 删除 编辑
shared pool又称共享池,主要是用来存放sql,结构包括library cache,dictionary cache,control structures,
至于large pool称大型池,主要是用来shared server operations,backup and restore tasks,

The Streams pool is a portion of memory in the System Global Area (SGA) that is used by Streams. The Streams pool stores buffered queue messages in memory, and it provides memory for capture processes and apply processes. The Streams pool always stores LCRs captured by a capture process, and it stores LCRs and messages that are enqueued into a buffered queue by applications or users.

来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

下一篇: ORACLE锁机制分析
请登录后发表评论 登录


  • 博文量
  • 访问量