Saturday, October 20, 2012

5 ASMM( Automatic Shared Memory Management)

New features in 10g to help manage the SGA. When SGA_TARGET large then 0, it means the ASMM is enable. Disable the AMM by set MEMORY_TARGET to 0. after the setting, you can see the SGA_TARGET change from 0 to 608MB.

Enable ASMM

set the memory_target=0 is to disable the AMM. This will change the AMM to ASMM.

show parameter target
alter system set MEMORY_TARGET=0;
show parameter target
image_thumb[5]
If you don’t have the AMM enable, then just set the SGA_TARGET to enable the ASMM. SGA_TARGET is the dynamic value as long as you set it small than SGA_MAX_SIZE.
alter system set sga_target=500M scope=both;
image
  • SGA_TARGET must small than SGA_MAX_SIZE.
  • SGA_MAX_SIZE is static value. To change the SGA_MAX_SIZE require bounce the oracle instance.

V$SGA_DYNAMIC_FREE_MEMORY

Show the free memory that we can add to the SGA. The difference between SGA_MAX_SIZE and SGA_TARGET. ( SGA_MAX_SIZE- SGA_TARGET)

show parameter sga
select * from V$SGA_DYNAMIC_FREE_MEMORY;

image_thumb[7]

V$SGA_DYNAMIC_COMPONET

Show the size of the SGA dynamic components.

COLUMN component FORMAT A24
SELECT  component, current_size, min_size, max_size,user_specified_size FROM  v$sga_dynamic_components;
image_thumb[10]

V$SGA_TARGET_ADVICE

We can use it to determine whether the SGA_TARGET is bigger enough or we can reduce the memory.

select * from V$SGA_TARGET_ADVICE;

image_thumb[12]

IceRocket Tags: ,

5 comments:

  1. I picture this could be numerous upon the written content material? nevertheless I nonetheless consider that it may be suitable for just about any type of topic subject matter, as a result of it will regularly be gratifying to resolve a warm and delightful face or maybe pay attention a voice whilst initial landing. https://royalcbd.com/product/cbd-gummies-10mg/

    ReplyDelete
  2. I picture this could be numerous upon the written content material? nevertheless I nonetheless consider that it may be suitable for just about any type of topic subject matter, as a result of it will regularly be gratifying to resolve a warm and delightful face or maybe pay attention a voice whilst initial landing. https://royalcbd.com/product/cbd-gummies-10mg/

    ReplyDelete
  3. replica Louboutin shoes After working alongside some of the replica men Louboutin shoes best French shoe designers, Christian Louboutin launched his own label in 1991. Designed in Paris and crafted in Italy by skilled artisans, the label’s sophisticated heels, sneakers and flats fuse style with comfort. An A-list favourite, its iconic red lacquered soles are internationally recognised. Look out for the classic ‘So Kate’ and ‘Pigalle’ designs, which will bring polish to any look. Plus, don’t miss the label’s sculptural studded handbags.

    ReplyDelete
  4. replica balenciaga shoes pursuit of modern shoes includes essential styles such as Triple S and Hoodies & Outwear. Buy now, cheap balenciaga pool slide free shipping.

    ReplyDelete

 

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