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';
V$streams_pool_advice
select * from v$streams_pool_advice;
Reference
http://docs.oracle.com/cd/E25054_01/server.1111/e25789/memory.htm
0 comments:
Post a Comment