An Oracle instance is shown as a Windows service (a background process registered with the operating system). The service is started by Windows and requires no user interaction to start. It contains the memory structures and threads needed to access the database.
Oracle Database Thread | Description | Required/Optional |
---|---|---|
DBW0 | database writer | Required |
LGWR | log writer | Required |
PMON | process monitor | Required |
SMON | system monitor | Required |
CKPT | checkpoint process (thread on Windows) that runs by default on Windows | Optional |
ARCH0 | archive process (or thread on Windows) | Optional |
RECO | distributed recovery background process | Optional |
No comments:
Post a Comment