RelationalDBDesign RelationalDBDesign


Instance Architecture   «Prev  Next»
Lesson 18 Other Oracle processes
Objective Identify other Oracle processes that may be running on your server.

Oracle Processes such as Database Writer, Log Writer, System Monitor, Process Monitor, Archiver

Main processes

Identify other Oracle processes that may be running on your server. The processes that you have learned about so far in this module are the major ones that you need to be concerned about when managing an Oracle instance. These include:
  1. The Database Writer
  2. The Log Writer
  3. The System Monitor
  4. The Process Monitor
  5. The Archiver

Other processes

There are other processes however, that you may see running, depending on how you have configured your database. Here are some of them:

LCKO:Lock processes: Used with Oracle Parallel Server to provide inter-instance locking. This allows two instances operating on the same database to coordinate their activities.
SNPO: Job Queue processes: Job Queue processes are used to run scheduled jobs. The replication option uses these to refresh snapshots, hence the SNP abbreviation. SNP processes also start jobs scheduled with the DBMS_JOBS package.
QMNO:Queue Monitor processes: Queue Monitor processes monitor the message queues as part of Oracle's Advanced Queuing feature.
Dnnn-Dispatcher processes: Dispatcher processes exist when the multi-threaded server option is being used. Dispatchers link up incoming connections with available shared server processes.
Snnn-Shared Server processes: Shared Server processes are also used with the multi-threaded server option. Multiple user connections share a single server process,k reducing the demand on server resources.

Latches

A latch is a simple, low-level serialization mechanism that coordinates multiuser access to shared data structures, objects, and files. Latches protect shared memory resources from corruption when accessed by multiple processes. Specifically, latches protect data structures from the following situations:
  1. Concurrent modification by multiple sessions
  2. Being read by one session while being modified by another session
  3. Deallocation (aging out) of memory while being accessed
Typically, a single latch protects multiple objects in the SGA. For example, background processes such as DBW and LGWR allocate memory from the shared pool to create data structures. To allocate this memory, these processes use a shared pool latch that serializes access to prevent two processes from trying to inspect or modify the shared pool simultaneously. After the memory is allocated, other processes may need to access shared pool areas such as the library cache, which is required for parsing. In this case, processes latch only the library cache, not the entire shared pool. Unlike enqueue latches such as row locks, latches do not permit sessions to queue. When a latch becomes available, the first session to request the latch obtains exclusive access to it. The phenomenon of latch spinning occurs when a process repeatedly requests a latch in a loop, whereas latch sleeping occurs when a process releases the CPU before renewing the latch request. Typically, an Oracle process acquires a latch for an extremely short time while manipulating or looking at a data structure. For example, while processing a salary update of a single employee, the database may obtain and release thousands of latches. The implementation of latches is operating system-dependent, especially in respect to whether and how long a process waits for a latch. An increase in latching means a decrease in concurrency. For example, excessive hard parse operations create contention for the library cache latch. The V$LATCH view contains detailed latch usage statistics for each latch, including the number of times each latch was requested and waited for.

Other Processes - Quiz

Try the following quiz to test your knowledge of these processes.
Other Processes - Quiz