The Problem We have had some instances where it seemed that starting rac databases through sqlplus caused performance issues (high load on database server ). Restarting the nodes using srvctl seemed to resolve the performance issue. "Is there any difference between using srvctl vs using sqlplus for starting or stopping one or more database nodes."? The Solution The Differences between SQLPLUS and SRVCTL There are some differences between the use of SQLPLUS and SRVCTL utilities. - Both … [Read more...] about Difference between using srvctl vs using sqlplus for start/stop one or more Oracle Database Instances
Oracle 10g
Understanding Oracle Database Automatic SGA Memory Tuning
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
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