In all of my recent DBA experience (including databases in Oracle’s cloud), this is the most common method for managing… Read more
Automatic Memory Management- Memory Structures
AMM is sort of a one-stop shop for all of your memory settings. The DBA can now get away with… Read more
Server Processes- Oracle Processes
Server processes are those that perform work on behalf of a client session. They are the processes that ultimately receive… 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
Java Pool- Memory Structures
The Java pool was added to support running Java in the database. If you code a stored procedure in Java,… Read more
DMnn/DWnn: Data Pump Master/Worker Processes- Oracle Processes
Data Pump runs entirely in the server and the API to it is via PL/SQL. Since Data Pump runs in… 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
Managing Blocks in the Buffer Cache- Memory Structures
For simplicity, assume that there’s just a single default pool. Because the other pools are managed in the same way,… 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