• Skip to primary navigation
  • Skip to main content
  • Skip to primary sidebar

The Geek Diary

CONCEPTS | BASICS | HOWTO

  • OS
    • Linux
    • CentOS/RHEL
    • Solaris
    • Oracle Linux
    • Linux Services
    • VCS
  • Database
    • oracle
    • oracle 12c
    • ASM
    • mysql
    • MariaDB
    • Data Guard
  • DevOps
    • Docker
    • Shell Scripting
  • Interview Questions
  • Big Data
    • Hadoop
    • Cloudera
    • Hortonworks HDP

New Background Processes In Oracle Database 10g

By Devraj

The background processes of the Oracle instance manage memory structures, asynchronously perform I/O to write data to a file on a disk, and perform general maintenance tasks. Each background process has a separate task but works with the other processes as well.

The post provides information on some new and some pre-existing background processes in 10G which may be unfamiliar.

Background Process Description
MMAN Memory Manager
RVWR Recovery Writer
CTWR Change Tracking Writer
MMNL Memory Monitor Light
MMON Manageability Monitor
M000 MMON background slave
CJQn Job Queue monitoring
RBAL ASM rebalancing process
ARBx Process managed by RBAL to do the actual rebalancing of ASM
ASMB Process used to provide information to and from the Cluster Synchronization Services used by ASM to manage the disk resources

MMAN

– SGA Background Process
– The Automatic Shared Memory Management feature uses a new background process named Memory Manager (MMAN).
– MMAN serves as the SGA Memory Broker and coordinates the sizing of the memory components. The SGA Memory Broker keeps track of the sizes of the components and pending resize operations

RVWR

– “Flashback database” is a new feature introduced in 10g.
– Flashbacking a database means going back to a previous database state.
– The Flashback Database feature provides a way to quickly revert an entire Oracle database to the state it was in at a past point in time.
– This is different from the traditional point in time recovery.
– A new background process Recovery Writer ( RVWR) introduced which is responsible for writing flashback logs which stores pre-image(s) of data blocks.
– One can use Flashback Database to back out changes that:

  • Have resulted in logical data corruptions.
  • Are a result of user error.

– This feature is not applicable for recovering the database in case of media failure.
– The time required for flashbacking a database to a specific time in past is DIRECTLY PROPORTIONAL to the number of changes made and not on the size of the database.

Jnnn

These are job queue processes which are spawned as needed by CJQ0 to complete scheduled jobs. This is not a new process.

CTWR

This is a new process Change Tracking Writer (CTWR) which works with the new block changed tracking features in 10g for fast RMAN incremental backups.

MMNL

The Memory Monitor Light (MMNL) process is a new process in 10g which works with the Automatic Workload Repository new features (AWR) to write out full statistics buffers to disk as needed.

MMON

– The Manageability Monitor (MMON) process was introduced in 10g and is associated with the Automatic Workload Repository new features used for automatic problem detection and self-tuning.
– MMON writes out the required statistics for AWR on a scheduled basis.

M000

MMON background slave (m000) processes.

CJQn

This is the Job Queue monitoring process which is initiated with the job_queue_processes parameter. This is not new.

RBAL

This is the ASM related process that performs rebalancing of disk resources controlled by ASM.

ARBx

– These processes are managed by the RBAL process and are used to do the actual rebalancing of ASM controlled disk resources.
– The number of ARBx processes invoked is directly influenced by the asm_power_limit parameter.

ASMB

– The ASMB process is used to provide information to and from the Cluster Synchronization Services used by ASM to manage the disk resources.
– It is also used to update statistics and provide a heartbeat mechanism.

ASM background processes in 11gR2
Understanding Oracle Background Processes
New Background Processes In Oracle Database 12c

Filed Under: oracle, Oracle 10g

Some more articles you might also be interested in …

  1. How To Create Device Alias For ASM Disks Using mknod On Linux/Unix
  2. How to Drop/Truncate Multiple Partitions in Oracle 12C
  3. How To Calculate The Required Network Bandwidth Transfer Of Redo In Data Guard Environments
  4. Beginners Guide to Working with spfile in Oracle ASM
  5. How to Roll Forward a standby database using RMAN incremental backup in 11g
  6. New Oracle Net features in version 12c
  7. Oracle Database: Redo log operations (Add/Drop/Change Location)
  8. How to Convert STANDARD ASM to FLEX ASM in 12C
  9. How to Verify if a Disk/Partition is in Use by Oracle ASM, was used by Oracle ASM or is never used by Oracle ASM
  10. Adding Users to Oracle Passwordfile (Oracle Passwordfile Authentication)

You May Also Like

Primary Sidebar

Recent Posts

  • How to disable ACPI in CentOS/RHEL 7
  • How to Use real-time query to access data on a physical standby database
  • CentOS/RHEL 8: “ACPI MEMORY OR I/O RESET_REG” Server Hung after reboot
  • How to Create a Physical Standby Database by Using SQL and RMAN Commands
  • Archives
  • Contact Us
  • Copyright

© 2021 · The Geek Diary