A learning note for Oracle10G Process System: As Oracle10G is a multi-process multi-thread database, SQLServer is a single-process multi-thread database Ora
Oracle 10G process system learning notes: Since Oracle 10G is a multi-process multi-thread database, and SQL Server is a single-process multi-thread database Ora
An Oracle 10g Process System Study note:
Since Oracle 10 Gb is a multi-process and multi-thread database, SQL Server is a single-process and multi-thread database.
Oracle instances mainly have three types of processes.
1. server process
2. background processes
3. Subordinate Process
Server process: divided into VPC process and Shared Server process
Background process:
1, PMON (Process Monitor)
2, SMON (System Monitor)
3. RECO (distributed database recovery)
4. CKPT (Checkpoint Process)
5, DBWn (Data writer)
6. LGWr (log writer)
7. ARCn (archiving process)
Subordinate process:
I/O subordinate process and parallel Query Process