Download to read offline
Uploaded byPankaj Mandal
Memory management in oracle 11g r2
Oracle 11g R2 introduced automatic memory management which takes care of dynamically expanding and shrinking the SGA and PGA based on instance needs. Only two parameters, memory_target and memory_max_target, need to be set. Memory_target sets the initial usable system memory size while memory_max_target defines the maximum amount of memory Oracle can use. For example, memory_max_target could be set to 500MB and memory_target to 350MB initially.
Memory management in oracle 11g r2
- 1. MEMORY MANAGEMENT INORACLE 11G R2
- 2. MEMORY PARAMETERS Newautomatic memory management feature Takes care of both major memory component Shared Global Area (SGA) Program Global Area (PGA) Automatically expand and shrunk SGA and PGA based on instance needs.
- 3. MEMORY PARAMETERS (CONT..) Two parameters are set need to set memory_target memory_max_target memory_target Sets the system-wide usable memory and lets Oracle tune the SGA and PGA both. DBA can change value for this parameter using alter system command.
- 4. MEMORY PARAMETERS (CONT..) memory_max_target Maximum value of memory Oracle can use. The value you set for the memory_max_target parameter is the max value uptp which you can adjust the memory_target parameter’s value. E.g memory_max_target = 500MB memory_target = 350MB sga_target = 0 pga_aggregate_target = 0
- 5. THANK YOU Contact me:- pankajmitsom@gmail.com