Process Structure, User Process, Server Process, Background Processes |
|
|
|
Écrit par OCA
|
19-03-2008 |
- User Process
- starts at the time the user requests interaction to the Oracle server through an access tool
- establishes a connection through the server process
- Server Process
- starts when the user establishes a connection
- connects to the Oracle instance on behalf of the user process and opens a session
- Background Processes
- start when an Oracle instance is started
- maintain and enforce relationships between physical and memory structures
- 5 Mandatory Processes
DBWn
|
Database Writer |
LGWR |
Log Writer |
SMON |
System Monitor |
PMON |
Process Monitor |
CKPT |
Checkpoint |
- Optional Background Processes
ARCn
|
Archiver
|
CJQ0 |
Coordinator Job Queue |
Dnnn |
Dispatcher |
LCKn |
RAC Lock Manager-Instance Locks |
LMDn |
RAC DLM Monitor-Remote Locks |
LMON |
RAC DLM Monitor-Global Locks |
LMS |
RAC Global Cache Service |
Pnnn |
Parallel Query Slaves |
QMNn |
Advanced Queuing |
RECO |
Recoverer |
Snnn |
Shared Server |
|
Dernière mise à jour : ( 15-04-2008 )
|