Saturday, January 13, 2018

Oracle Background Process

To maximize the performance and accommodate many users, a multiprocessing oracle system use some additional database process called background process.
The relationship between the physical and memory structures is maintained and enforced by Oracle’s background processes.

Mandatory background process :
  • System monitor (SMON)
  • Process monitor (PMON)
  • Database writer (DBWR)
  • Log writer (LGWR)
  • Checkpoint (CKPT)
Optional process:
  • Archival  (ARCn)

No comments:

Post a Comment

30 Detailed Daily Speaking Scripts (Advanced Fluency)

  🟦 DAYS 1–10: BASIC FLUENCY & CLARITY ✅ Day 1 – Professional Self‑Introduction Example Script: “Let me introduce myself. My name is An...