Friday, April 25, 2008

How To Use Automatic Shared Memory Management (ASMM) In Oracle10g

Pls refer to metalink doc. Note:295626.1
Keys things are:
1. To use the feature in 10g, we need to set sga_target value. The default value is 0 , which means disable ASMM.

2. Important dict tables
v$sga_dynamic_component
v$sga_dynamic_free_memory
v$sga_resize_ops