The QMNC process is to the AQ tables what the CJQ0 process is to the job table. It monitors the… Read more
Category: Multiple Block Sizes
FBDA: Flashback Data Archiver Process- Oracle Processes
The flashback data archiver process is the key component of the flashback data archive capability—the ability to query data “as… Read more
Shared Server Connections- Oracle Processes
Let’s now take a look at the shared server process in more detail. This type of connection mandates the use… Read more
Potential Benefits of a Shared Server- Oracle Processes
What are the benefits of a shared server, bearing in mind that you have to be somewhat careful about the… Read more
Dedicated Server Connections- Oracle Processes
In dedicated server mode, there will be a one-to-one mapping between a client connection and a server process (or thread,… Read more
Background Processes- Oracle Processes
The Oracle instance is made up of two things: the SGA and a set of background processes. The background processes… 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
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