MEMORY ARCHITECTURE
A. SGA (System Global Area) – Shared Memory Purpose: Shared by all users and processes. Allocated at instance startup. Main Components: 1. Database Buffer…
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
INSTANCE vs DATABASE
DATABASE = Physical files on disk (datafiles, control files, redo logs)INSTANCE = Memory structures (SGA, PGA) + background processes that access the database Key…
FUNDAMENTALS FIRST
What is Data? Data = Raw facts without contextExample: “25”, “John”, “2024-12-21” What is Information? Information = Data with context/meaningExample: “John is 25 years…
Oracle CTAS: The Complete Guide to Copying Tables (With All Dependencies)
Most Oracle developers start with the basic table copy command: However, this only copies about 20% of what makes your table functional. If you’ve…
How to Export Oracle Standby Data via Network Link
Introduction Running data exports on your primary Oracle database during business hours can slow down operations and frustrate users. This guide shows you how…
How to Recover Truncated Table Using Flashback in Oracle
Truncating a table removes all data instantly, and a simple rollback cannot undo it. But if Flashback Database was enabled before the truncate occurred,…
Types of Databases
Early in my DBA career, I thought all databases were basically the same—just different brands. Oracle, MySQL, SQL Server—they all seemed to do the…
Relational Database Concepts
Back in 1970, an IBM researcher named Edgar F. Codd published a paper that changed everything. He proposed organizing data using mathematical set theory…
Database Management System (DBMS)
Let me tell you about a moment early in my career that completely changed how I understood databases. I was working as a junior…
Database vs Spreadsheet vs Flat Files
Here’s a conversation I’ve had countless times: Developer: “Why do we need a database? Can’t we just use Excel? It’s simpler and everyone knows…
Understanding Databases
Where does your company store customer information? Inventory data? Financial transactions? Employee records? If you answered “in a database,” you’re correct. However, have you…
Introduction
When I started as an Oracle DBA 15 years ago, I felt completely overwhelmed. The architecture seemed complex, the parameters endless, and the information…