Background Processes (113)

最新推荐文章于 2025-12-09 09:24:19 发布

转载最新推荐文章于 2025-12-09 09:24:19 发布 · 110 阅读

文章标签：

#数据库

本文介绍了Oracle数据库系统中使用的多种后台进程及其作用，如数据库写进程(DBWn)、日志写进程(LGWR)等，并指出这些进程在实例启动时会自动创建。还提供了查询后台进程信息的方法。

To maximize performance and accommodate many users, a multiprocess Oracle
system uses some additional Oracle processes called background processes.
An Oracle instance can have many background processes; not all are always present.
There are numerous background processes. See the V$BGPROCESS view for more
information on the background processes. The background processes in an Oracle
instance can include the following:
■ Database Writer Process (DBWn)
■ Log Writer Process (LGWR)
■ Checkpoint Process (CKPT)
■ System Monitor Process (SMON)
■ Process Monitor Process (PMON)
■ Recoverer Process (RECO)
■ Job Queue Processes
■ Archiver Processes (ARCn)
■ Queue Monitor Processes (QMNn)
■ Other Background Processes
On many operating systems, background processes are created automatically when an
instance is started.