首页 > 应用开发 > IT综合 > Background Processes (113)

Background Processes (113)

原创 IT综合 作者:tsinglee 时间:2007-10-30 12:29:03 0 删除 编辑

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.

1. 通过视图v$BGPROCESS可查询后台进程的信息
2. 包括数据库写进程 , 系统监视进程 等
3. 当实例启动的时候 , 后台进程被自动启动


来自 “ ITPUB博客 ” ,链接:,如需转载,请注明出处,否则将追究法律责任。

上一篇: Server Processes (112)
请登录后发表评论 登录
  • 博文量
  • 访问量