The Java pool was added to support running Java in the database. If you code a stored procedure in Java,… Read more
Category: PMON: The Process Monitor
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
Multiple Block Sizes- Memory Structures
You can have multiple database block sizes in the same database. You can have a mixture of the “default” block… Read more