Saturday, October 27, 2012

3 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

3 comments:

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

    appvn app

    ReplyDelete
    Replies
    1. Big data is a term that describes the large volume of data – both structured and unstructured – that inundates a business on a day-to-day basis. big data projects for students But it’s not the amount of data that’s important.Project Center in Chennai

      Spring Framework has already made serious inroads as an integrated technology stack for building user-facing applications. Corporate TRaining Spring Framework the authors explore the idea of using Java in Big Data platforms.

      Spring Training in Chennai

      The new Angular TRaining will lay the foundation you need to specialise in Single Page Application developer. Angular Training

      Delete
  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