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
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;
- 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;
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] image_thumb[10]](http://lh5.ggpht.com/-FvZpxA5mPDQ/UINseOOZMFI/AAAAAAAABcc/B7VmaT8YpVo/image_thumb%25255B10%25255D_thumb.png?imgmax=800)
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;
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/
ReplyDeleteI 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/
ReplyDeletereplica 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.
ReplyDeletereplica rolex lady datejust watches
ReplyDeletereplica rolex milgauss watches
replica rolex oyster perpetual watches
replica rolex sea dweller watches
replica rolex sky dweller watches
replica rolex submariner watches
replica rolex yacht master watches
replica rolex yacht master ii watches
replica omega 1957 limited edition watches
replica omega aquaterra watches
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