ARCN QMNN【每日一译】--2012-10-14

Archiver Processes (ARCn)
The archiver process (ARCn) copies redo log files to a designated storage device after
a log switch has occurred. ARCn processes are present only when the database is in

ARCHIVELOG mode, and automatic archiving is enabled.

ARCN拷贝REDO日志文件到一个指定的存储设备在发生日志切换时候。ARCN进程只

出现在数据库是归档模式，并且自动归档是被开启的。

An Oracle instance can have up to 10 ARCn processes (ARC0 to ARC9). The LGWR
process starts a new ARCn process whenever the current number of ARCn processes is
insufficient to handle the workload. The alert log keeps a record of when LGWR starts

a new ARCn process.

ORACLE实例最大有10个ARCN进程。LGWR进程启动一个新的ARCN进程当当前的ARCN

进程不足处理负载的时候。ALERT日志记录了当LGWR进程启用一个新的ARCN进程时。

If you anticipate a heavy workload for archiving, such as during bulk loading of data,
you can specify multiple archiver processes with the initialization parameter LOG_
ARCHIVE_MAX_PROCESSES. The ALTER SYSTEM statement can change the value of
this parameter dynamically to increase or decrease the number of ARCn processes.
However, you do not need to change this parameter from its default value of 1,
because the system determines how many ARCn processes are needed, and LGWR
automatically starts up more ARCn processes when the database workload requires

more.

如果你预期有一个繁重归档负载，像在批量导入数据，你可以指定多个归档进程通过

初始化参数LOG_ARCHIVE_MAX_PROCESSES.ALTER SYSTEM语句可以动态增加

或减少ARCN进程的值。你不需要修改这个参数虽然它的默认值是1，因为系统决定

需要多少ARCN进程，并且LGWR会自动的启动更多的ARCN进程当数据库负载需要

更多的时候。

Queue Monitor Processes (QMNn)
The queue monitor process is an optional background process for Oracle Streams
Advanced Queuing, which monitors the message queues. You can configure up to 10
queue monitor processes. These processes, like the job queue processes, are different
from other Oracle background processes in that process failure does not cause the
instance to fail.

QMNN进程是一个额外的后台进程对于ORACLE流高级对列，它监视着信息对列，你

可以配置最多10个对列监控进程。这些进程像任务对列进程，不同于其它的后台进程，因为

它的失败不会不会引起实例的失败。