Oracle 12c 数据库进程
进程名 | 全名 | 组件范畴 |
AQPC | AQ Process Coordinator | Database instances Advanced Queueing |
ARSn | ASM Recovery Slave Process （进程范围ARS0~ARS9） | Oracle ASM instances |
BWnn | Database Writer Process | Database instances |
FENC | Fence Monitor process | Oracle ASM instance |
GCRn | Global Conflict Resolution Slave Process | Database instances,Oracle ASM instances,Oracle RAC |
IPC0 | IPC Service Background Process | Oracle RAC |
LDDn | Global Enqueue Serivce Daemon Helper Slave | Database instances,Oracle ASM instances,Oracle RAC |
LGnn | Log Writer Worker | Database instances |
LREG | Listener Registration Process | Database instances,Oracle ASM instances,Oracle RAC |
OFSD | Oracle File Server Background Process | Database instances, Oracle RAC |
QMnn | AQ Master Slave Process | Database instances Advanced Queueing |
RM | RAT Masking Slave Process | Database instances |
RMON | Rolling Migration Monitor Process | Oracle ASM instance, Oracle RAC |
RPOP | Instant Recovery Repopulation Daemon | Database instances |
SAnn | SGA Allocator(SA00~SAzz) | Database instances |
SCCn | ASM Disk Scrubbing Slave Check Process | Oracle ASM instances |
SCRB | ASM Disk Scrubbing Master Process | Oracle ASM instances |
SCRn | ASM Disk Scrubbing Slave Repair Process | Oracle ASM instances |
SCVn | ASM Disk Scrubbing Slave Verify Process | Oracle ASM instances |
TTnn | Redo Transport Slave Process | Database instances,Data Guard |
VUBG | Volume drive Umbilicus Background | Oracle ASM instances,Oracle ASM Proxy instances |
要使Oracle 12c处于多线程模式，我们必须将兼容性设置为12.0.0.0以上，且设置初始化参数 THREADED_EXECUTION为TRUE。启动该功能的步骤如下。
（1）关闭所有实例。
（2）修改初始化参数 THREADED_EXECUTION的值。
SQL>startup upgrade
SQL>alter system set threaded_execution=true scope=spfile;
（3）重启所有实例。
本公众号是个人学习工作笔记，希望大家发现问题能及时和我本人沟通，希望你与我共同成长。个人微信zgtj12306。
欢迎关注“自学Oracle”
