Unless your system is overloaded, or you need to use a shared server for a specific feature, a dedicated server… Read more
Category: Automatic Memory Management
Pnnn: Parallel Query Execution Servers-Oracle Processes
Parallel query is the capability to take a SQL statement such as a SELECT, CREATE TABLE, CREATE INDEX, UPDATE, and… Read more
RECO: Distributed Database Recovery- Oracle Processes
RECO has a very focused job: it recovers transactions that are left in a prepared state because of a crash… Read more
Manual Shared Memory Management- Memory Structures
Manual shared memory management should be rarely used; therefore, I’m not going to discuss this technique in detail. This is… Read more
In-Memory Pool- Memory Structures
Database In-Memory features a highly optimized in-memory column store (IM column store) that functions with the existing row formatted buffer… Read more
Large Pool- Memory Structures
The large pool is not so named because it is a “large” structure (although it may very well be large… Read more
Shared Pool- Memory Structures
The shared pool is one of the most critical pieces of memory in the SGA, especially with regard to performance… Read more