In Oracle Database 10g, Automatic Shared Memory Management (ASMM) feature is introduced to automatically determine the size of Database buffer cache (default pool), Shared Pool, Large pool and Java pool (starting with 10gR2, the streams pool is included) by setting the parameter SGA_TARGET. This feature reduces the tasks like dynamically analyzing the database workload and redistribute memory across the SGA pools. Benefits of Automatic Shared Memory Management Automatic Shared Memory … [Read more...] about Understanding Oracle Database Automatic SGA Memory Tuning
Oracle 10g
New Background Processes In Oracle Database 10g
The background processes of the Oracle instance manage memory structures, asynchronously perform I/O to write data to a file on a disk, and perform general maintenance tasks. Each background process has a separate task but works with the other processes as well. The post provides information on some new and some pre-existing background processes in 10G which may be unfamiliar. Background ProcessDescription MMANMemory Manager RVWRRecovery Writer CTWRChange Tracking Writer … [Read more...] about New Background Processes In Oracle Database 10g