The QMNC process is to the AQ tables what the CJQ0 process is to the job table. It monitors the… Read more
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
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
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
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
Dedicated Server vs. Shared Server vs. DRCP- Oracle Processes
Before we examine the rest of the processes, let’s discuss why there are three main connection modes and when one… 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