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
I have read your blog its very attractive and impressive. I like it your blog.
ReplyDeleteappvn app
Cartier is the renowned replica watches French jeweller and watchmaker with a history of pioneering replica cartier tank francaise watches design and a drive for excellence. The first references to Cartier wristwatches date back to 1888. Late in the 19th century it was pocket and chatelaine watches that were most popular, but Louis Cartier saw a future in timepieces that could be worn on the wrist.
ReplyDelete