Saturday, October 27, 2012

2 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

2 comments:

  1. I have read your blog its very attractive and impressive. I like it your blog.

    appvn app

    ReplyDelete
  2. 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

 

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