The QMNC process is to the AQ tables what the CJQ0 process is to the job table. It monitors the… Read more
Category: Connections vs. Sessions
Remaining Common Focused Processes- Oracle Processes
Depending on the features of Oracle you are using, other focused processes may be visible. Some are listed here with… 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
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
Dedicated/Shared Server Wrap-Up- Oracle Processes
Unless your system is overloaded, or you need to use a shared server for a specific feature, a dedicated server… Read more
Pnnn: Parallel Query Execution Servers-Oracle Processes
Parallel query is the capability to take a SQL statement such as a SELECT, CREATE TABLE, CREATE INDEX, UPDATE, and… Read more
SMON: The System Monitor- Oracle Processes
SMON is the process that gets to do all of the system-level jobs. Whereas PMON was interested in individual processes,… Read more