The QMNC process is to the AQ tables what the CJQ0 process is to the job table. It monitors the… Read more
Category: Automatic Memory Management
Utility Background Processes- Oracle Processes
These background processes are totally optional, based on your need for them. They provide facilities not necessary to run the… Read more
Connections vs. Sessions- Oracle Processes-1
It surprises many people to discover that a connection is not synonymous with a session. In most people’s eyes, they… 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
Connections vs. Sessions- Oracle Processes-2
We have, however, closed all of our sessions. If we open another session using some other user account and query… Read more
System Global Area (SGA) Memory Management- Memory Structures
The SGA is a group of shared memory structures that contain data and control structures for an Oracle instance. When… 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
DBWn: Database Block Writer- Oracle Processes
The database block writer (DBWn) is the background process responsible for writing dirty blocks to disk. DBWn will write dirty… Read more
PMON: The Process Monitor- Oracle Processes
This process is responsible for cleaning up after abnormally terminated connections. For example, if your dedicated server “fails” or is… 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