Saturday, October 20, 2012

13 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: ,

13 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
  5. All students need to do to get Homework Help or assignment help is registered on our website, pay a minor charge, and submit the assignment by the deadline. As soon as we receive the project, we send it to one of our expert professional tutors, who will complete it within the deadline. The assignment is only given to the student after it has been thoroughly checked.

    ReplyDelete
  6. Looking for a reliable online assignment help provider to help in the UAE? Don’t worry we got the solution to your problem. We offer all academic assignment services for students within the budget. Visit our website to learn

    ReplyDelete
  7. This new feature is very helpful for developers and they are happy and complete their tasks in short time. Do you agree with me? Dissertation help UK.

    ReplyDelete

  8. We are a top rated
    marketing assignment help
    Online service here with experts specializing in a wide range of disciplines ensuring you get the assignments that score maximum grades.

    ReplyDelete

 

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