Saturday, October 27, 2012

0 Streams Pool

Steams pool memory is used by Oracle stream only.

How to check streams pool size?

show parameter streams_pool
select * from v$sgastat where pool='streams pool';

image

V$streams_pool_advice

select * from v$streams_pool_advice;

image

Reference

http://docs.oracle.com/cd/E25054_01/server.1111/e25789/memory.htm

0 comments:

Post a Comment

 

SQL Panda Copyright © 2011 - |- Template created by O Pregador - |- Powered by Blogger Templates