The QMNC process is to the AQ tables what the CJQ0 process is to the job table. It monitors the… Read more
Category: PMON: The Process Monitor
LGWR: Log Writer- Oracle Processes
The LGWR process is responsible for flushing to disk the contents of the redo log buffer located in the SGA…. 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
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
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
Reduces the Memory Needed on the System- Oracle Processes
This is one of the most highly touted reasons for using a shared server: it reduces the amount of required… Read more
Automatic Shared Memory Management (ASMM)- Memory Structures
In all of my recent DBA experience (including databases in Oracle’s cloud), this is the most common method for managing… 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
Server Processes- Oracle Processes
Server processes are those that perform work on behalf of a client session. They are the processes that ultimately receive… Read more
Manual Shared Memory Management- Memory Structures
Manual shared memory management should be rarely used; therefore, I’m not going to discuss this technique in detail. This is… Read more