Server processes are those that perform work on behalf of a client session. They are the processes that ultimately receive… Read more
Category: Connections vs. Sessions
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
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
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