暂无图片
暂无图片
暂无图片
暂无图片
暂无图片

Oracle Database12c新特性:新增加的后台进程

原创 eygle 2013-08-07
1426

在Oracle Database 12c中,大量新的后台进程被引入进来,很多新特性的实现都和新的进程有关。如:



  1. Oracle 12c实现了多LGWR管理,这就引入了LG00-LG99一系列的后台进程;

  2. Oracle 12c扩展了多DBWR支持,BW36~BW99,这一列进程都会提高DBWR的写并行;

  3. Oracle 12c的多进程多线程模式 - MPMT,引入SCMN进程作为线程监听进程;


下表对这些进程做了一定的梳理和说明,供大家参考。








































































































































































进程名全名简要描述详细描述组件范畴
AQPCAQ Process CoordinatorPer instance AQ global coordinatorAQPC is responsible for performing administrative tasks for AQ Master Class Processes including commands like starting, stopping, and other administrative tasks. This process is automatically started on instance startup.Database instances Advanced Queueing
ARSnASM Recovery Slave Process(进程范围 ARS0-ARS9)Recovers ASM transactional operationsThe ASM RBAL background process coordinates and spawns one or more of these slave processes to recover aborted ASM transactional operations. These processes run only in the Oracle ASM instance.Oracle ASM instances
BWnnDatabase Writer ProcessWrites modified blocks from the database buffer cache to the data filesSee the Long Description for the DBWn process in this table for more information about the BWnn process.Database instances
FENCFence Monitor ProcessProcesses fence requests for RDBMS instances which are using Oracle ASM instancesCSS monitors RDBMS instances which are connected to the Oracle ASM instance and constantly doing I/Os. When the RDBMS instance terminates due to a failure, all the outstanding I/O's from the RDBMS instance should be drained and any new I/O's rejected. FENC receives and processes the fence request from CSSD.Oracle ASM instances
GCRnGlobal Conflict Resolution Slave ProcessPerforms synchronous tasks on behalf of LMHBGCRn processes are transient slaves that are started and stopped as required by LMHB to perform synchronous or resource intensive tasks.Database instances, Oracle ASM instances, Oracle RAC
IPC0IPC Service Background ProcessCommon background server for basic messaging and RDMA primitives based on IPC (Inter-process communication) methods.IPC0 handles very high rates of incoming connect requests, as well as, completing reconfigurations to support basic messaging and RDMA primitives over several transports such as UDP, RDS, InfiniBand and RC.Oracle RAC
LDDnGlobal Enqueue Service Daemon Helper SlaveHelps the LMDn processes with various tasksLDDn processes are slave processes spawned on demand by LMDn processes. They are spawned to help the dedicated LMDn processes with various tasks when certain workloads start creating performance bottlenecks. These slave processes are transient as they are started on demand and they can be shutdown when no longer needed. There can be up to 36 of these slave processes (LDD0-LDDz).Database instances, Oracle ASM instances, Oracle RAC
LGnnLog Writer WorkerWrites redo logOn multiprocessor systems, LGWR creates worker processes to improve the performance of writing to the redo log. LGWR workers are not used when there is a SYNC standby destination. Possible processes include LG00-LG99.Database instances
LREGListener Registration ProcessRegisters the instance with the listenersLREG notifies the listeners about instances, services, handlers, and endpoint.Database instances, Oracle ASM instances, Oracle RAC
OFSDOracle File Server Background ProcessServes file system requests submitted to an Oracle instanceThis background process listens for new file system requests, both management (like mount, unmount, and export) and I/O requests, and executes them using Oracle threads.Database instances, Oracle RAC
QMnnAQ Master Class ProcessPer instance per AQ Master Class ProcessEach of this type of process represents a single class of work item such as AQ notification, queue monitors, and cross process.Database instances Advanced Queueing
RMRAT Masking Slave ProcessExtracts and masks bind values from workloads like SQL tuning sets and DB Replay capture filesThis background process is used with Data Masking and Real Application Testing.Database instances
RMONRolling Migration Monitor ProcessManages the rolling migration procedure for an Oracle ASM clusterThe RMON process is spawned on demand to run the protocol for transitioning an ASM cluster in and out of rolling migration mode.Oracle ASM instance, Oracle RAC
RPOPInstant Recovery Repopulation DaemonResponsible for re-creating and/or repopulating data files from snapshot files and backup filesThe RPOP process is responsible for re-creating and repopulating data files from snapshots files. It works with the instant recovery feature to ensure immediate data file access. The local instance has immediate access to the remote snapshot file's data, while repopulation of the recovered primary data files happens concurrently. Any changes in the data are managed between the instance's DBW processes and RPOP to ensure the latest copy of the data is returned to the user.Database instances
SAnn

SGA Allocator


(SA00 ~ SAzz)


Allocates SGAA small fraction of SGA is allocated during instance startup. The SAnn process allocates the rest of SGA in small chunks. The process exits upon completion of SGA allocation.Database instances
SCCnASM Disk Scrubbing Slave Check ProcessPerforms Oracle ASM disk scrubbing check operationSCCn acts as a slave process for SCRB and performs the checking operations. The possible processes are SCC0-SCC9.Oracle ASM instances
SCRBASM Disk Scrubbing Master ProcessCoordinates Oracle ASM disk scrubbing operationsSCRB runs in an Oracle ASM instance and coordinates Oracle ASM disk scrubbing operations.Oracle ASM instances
SCRnASM Disk Scrubbing Slave Repair ProcessPerforms Oracle ASM disk scrubbing repair operationSCRn acts as a slave process for SCRB and performs the repairing operations. The possible processes are SCR0-SCR9.Oracle ASM instances
SCVnASM Disk Scrubbing Slave Verify ProcessPerforms Oracle ASM disk scrubbing verify operationSCVn acts as a slave process for SCRB and performs the verifying operations. The possible processes are SCV0-SCV9.Oracle ASM instances
TTnnRedo Transport Slave ProcessShips redo from current online and standby redo logs to remote standby destinations configured for ASYNC transportTTnn can run as multiple processes, where nn is 00 to ZZ.Database instances, Data Guard
VUBGVolume drive Umbilicus BackgroundRelays messages between Oracle ASM instance and Oracle ASM Proxy instance that is used by ADVM (for ACFS)Oracle ASM instances, Oracle ASM Proxy instances

「喜欢这篇文章,您的关注和赞赏是给作者最好的鼓励」
关注作者
【版权声明】本文为墨天轮用户原创内容,转载时必须标注文章的来源(墨天轮),文章链接,文章作者等基本信息,否则作者和墨天轮有权追究责任。如果您发现墨天轮中有涉嫌抄袭或者侵权的内容,欢迎发送邮件至:contact@modb.pro进行举报,并提供相关证据,一经查实,墨天轮将立刻删除相关内容。

评论