Memory management involves maintaining optimal sizes for the Oracle instance memory structures as demands on the database change. Initialization parameter settings determine how SGA and…
View More Oracle Memory Management
Tag: sga
Oracle Automatic (Shared) Memory Management
Automatic Shared Memory Management Automatic Shared Memory Management: OverviewAutomatic Shared Memory Management (ASMM) simplifies the configuration of the System Global Area (SGA). ASMM uses memory…
View More Oracle Automatic (Shared) Memory Management
How to Increase MEMORY_TARGET
Before you can increase memory in oracle database, you must first understand four oracle memory parameters which govern the instance. SGA_TARGET and SGA_MAX_SIZE MEMORY_TARGET and…
View More How to Increase MEMORY_TARGET