Friday, October 26, 2012

2 Large Pool

Large Pool’s purpose is similar to Shared Pool. The major difference is it would be only used in the certain circumstances.

  • In MTS( Multi-threaded server) env, use for soft area and hash area.
  • Parallel Query
  • Large file’s IO Buffer
  • RMAN’s IO Buffer

Description of Figure 14-1 follows

* Image is from Oracle

Default value for Large Pool is 0. Max size is 2GB ( vary by os).

Unlike shared pool, Large Pool does not use LRU. Memory only can be free up when it is done using.

In MTS environment, if it large Pool is set. use large pool for UGA, otherwise, UGA is in the shared pool.

 

How to check the large pool size?

show parameter large_pool
select * from v$sgainfo;
select * from v$sgastat where pool='large pool';

 

image

_LARGE_POOL_MIN_ALLOC

Allocation size for the large pool.

col Parameter format a30
col value format a30
select a.ksppinm "Parameter", b.ksppstvl "Value" from x$ksppi a, x$ksppcv b 
where a.indx = b.indx and a.ksppinm like ('%large_pool_min_alloc%');

image

How to change the large Pool size?

alter system set large_pool_size=XXX; 

image

parallel_automatic_tuning

parallel_automatic_tuning is to enable the parallel execution.

image

 

Reference

http://docs.oracle.com/cd/E14072_01/server.112/e10820/initparams105.htm

2 comments:

  1. Cartier has recommended replica cartier tank francaise watchessuch as Cartier Tank, Cartier Santos and Cartier Ronde and so on. Every Cartier watch has its special charm, and Cartier watches are many people's dreams. Our shop provides different Cartier replica watches at very low prices. Just enjoy shopping here.

    ReplyDelete
  2. Rolex watches are crafted fake watches from the finest raw materials and assembled with scrupulous replica rolex watches attention to detail. Every component is designed, developed and produced in-house to the most exacting standards.

    ReplyDelete

 

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