SQL Syntax
To effectively write SQL queries and commands, understanding the basic syntax rules is essential. SQL syntax defines how you structure commands so 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
SQL Overview
SQL (Structured Query Language) is the standard language used to manage and interact with relational databases. If you’ve ever worked with data stored in…
Dispatcher Process (Dnnn) & Shared Server Process (Snnn)
Managing Network Requests Efficiently 🔄 🔍 What Are Dispatcher (Dnnn) and Shared Server (Snnn) Processes? ⚙️ How Does It Work? ⚙️ Running Mode 💡…
Space Management Coordinator Process (SMCO)
Keeping Space Optimized 📦 🔍 What is SMCO? The space management coordinator process (SMCO) schedules and coordinates various space management tasks in the database.…
Flashback Data Archiver Process (FBDA)
Archiving Changes for Table Flashback 📚 🔍 What is FBDA? The flashback data archiver process (FBDA) helps track and store transactional changes to tables…
Recovery Writer Process (RVWR)
Flashback Helper — Rewinding Database Time ⏪ 🔄 What is RVWR? The recovery writer process (RVWR) works with the Flashback Database feature. It reads…
Job Queue Coordinator Process (CJQ0)
Automating Job Execution Efficiently ⚙️ 🧾 What Is CJQ0? The job queue coordinator process (CJQ0) manages and schedules jobs in the database. It selects…
Archiver Process (ARCn)
Preserving Your Redo Logs for Recovery 📚 🧾 What Is ARCn? Archiver processes (ARCn) run only when the database is in ARCHIVELOG mode with…
Log Writer Process (LGWR)
Committing Redo Changes 🚀 🧾 What Is LGWR? The Log Writer Process (LGWR) is a crucial background process in Oracle Database that ensures all…
Recover Process (RECO)
Healing Distributed Transactions 🔄 🔁 What Is RECO? The Recoverer Process (RECO) is a background process responsible for automatically resolving in-doubt transactions in a…
MMON & MMNL (Manageability Monitor Processes)
Manageability Monitor Process (MMON) and Manageability Monitor Lite Process (MMNL) The Eyes That Watch Performance 👀 🧠 What Are MMON & MMNL? MMON and…
Checkpoint Process (CKPT)
Making Sure Changes Are Safe ✅ 🧠 What Is CKPT?The Checkpoint Process (CKPT) coordinates with the Database Writer (DBWn) to ensure that changes made…