<script type="text/javascript">
</script> <script type="text/javascript" src="http://pagead2.googlesyndication.com/pagead/show_ads.js"> </script>
Oracle10g实例的组成:
Oracle10g由主内存结构和几个Oracle后台进程组成。
1.主内存结构即为SGA
2.后台进程包括必需的和可选的两种:
必需的:
System Monitor | SMON | |||
Process Monitor | PMON | |||
Database Writer | DBWn(n代表数字1..n,表示可能有几个DBW在运行) | |||
Log Writer | LGWR | |||
Checkpoint | CKPT |
可选的:
Archiver | ARCn |
Recoverer | RECO |
Job Queue | Jnnn |
Job Queue Monitor | CJQn |
Queue Monitor | QMNn |
Parallel Query Slave | Qnnn |
Dispatcher | Dnnn |
Shared Server | Snnn |
Memory Manager | MMAN |
Memory Monitor | MMON |
Memory Monitor Light | MMNL |
Recovery Writer | RVWR |
Change Tracking Writer | CTWR |
关联考点:
Server Process代表用户跟Oracle实例进行通信。User Process在终端或者中间层服务器,而相对的Server Process在服务器,一般两者是一对一的关系,他不是Oracle实例的一部分。