AMM is sort of a one-stop shop for all of your memory settings. The DBA can now get away with… Read more
Category: QMNC and Qnnn
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
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