Database Writer Process (DBWn)
Writing Changes to Disk Efficiently 💾 🧠 What Is DBWn?The Database Writer process (DBWn) is responsible for writing modified (dirty) blocks from the database…
CATEGORY
Database
Master SQL, PostgreSQL, MySQL, MongoDB, and trending open-source databases. Learn optimization, design patterns, and best practices for modern data management.
323 articles
SMON – System Monitor Process
The Silent Healer of Your Database 🛠️ 🧠 What Is SMON?The System Monitor Process (SMON) is a background process that quietly handles critical recovery…
Listener Registration Process (LREG)
Let’s Talk to the Listener 📞 🧠 What Is LREG?The Listener Registration Process (LREG) is responsible for registering the database instance and its services…
Process Manager (PMAN)
🧠 What Is PMAN?The Process Manager (PMAN) is a background process in Oracle that manages and monitors other background processes, especially those that are…
Process Monitor (PMON)
🧠 What Is PMON?The Process Monitor (PMON) is one of Oracle’s background processes, quietly ensuring that failed processes and sessions are cleaned up properly.…
Backup Files
Keeping Your Data Safe 🧠 Why It Matters:Backups are essential for protecting your data from loss, corruption, or human error. Oracle provides both logical…
Automatic Diagnostic Repository (ADR)
Your Database’s Health Dashboard 🗄️ What is ADR? The Automatic Diagnostic Repository (ADR) is a central, system-wide place where Oracle stores all diagnostic and…
Database System Files
🧠 What Are Database System Files? These are special files Oracle uses to manage and run the database. They are different from data files,…
Schemas and Schema Objects
How Oracle Organizes Your Data Structures 🧠 What Is a Schema?A schema is a logical container that holds data structures called schema objects. 📂…
Tablespaces
🧠 What Is a Tablespace?A tablespace is a logical storage container for segments like tables, indexes, and other schema objects that consume space. Think…
Database Storage Structures
🧠 IntroductionEver wondered how Oracle actually stores your data? Let’s break it down — from big-picture storage like tablespaces, down to the tiniest data…
Application Containers
🧠 IntroductionAlready familiar with Pluggable Databases (PDBs) inside a Container Database (CDB)?Well, let’s zoom in on something special-purpose — the Application Container. Think of…