You are viewing a free preview of this lesson.
Subscribe to unlock all 10 lessons in this course and every other course on LearningBro.
What is Oracle Database
What is Oracle Database
Oracle Database is a multi-model relational database management system (RDBMS) developed by Oracle Corporation. It is one of the most widely used enterprise databases in the world, powering critical applications in banking, telecommunications, healthcare, government, and retail.
A Brief History
- 1977 — Larry Ellison, Bob Miner, and Ed Oates found Software Development Laboratories (later Oracle Corporation)
- 1979 — Oracle V2, the first commercially available SQL-based relational database, is released
- 1983 — Oracle V3, rewritten in C for portability across operating systems
- 1992 — Oracle 7 introduces PL/SQL stored procedures, triggers, and declarative referential integrity
- 1999 — Oracle 8i, the first "internet database" with Java support and HTTP capabilities
- 2003 — Oracle 10g introduces grid computing and Automatic Storage Management (ASM)
- 2007 — Oracle 11g adds Real Application Testing, Advanced Compression, and Flashback Data Archive
- 2013 — Oracle 12c launches with multitenant architecture and pluggable databases
- 2018 — Oracle 18c / 19c (Long Term Support release), autonomous capabilities
- 2023 — Oracle 23ai, featuring AI Vector Search and JSON Relational Duality
Oracle Database has evolved from a simple relational engine to a converged database supporting JSON, graph, spatial, text, and vector data — all within a single platform.
Why Oracle Database?
1. Enterprise Reliability
Oracle Database is trusted by the most demanding industries:
- 99.995% uptime with Oracle Real Application Clusters (RAC) and Data Guard
- Zero-downtime patching — apply patches while applications remain online
- Flashback technology — undo human errors without restoring from backup
2. Scalability
Oracle handles workloads from small applications to the world's largest databases:
| Capability | Limit |
|---|---|
| Maximum database size | Unlimited (exabytes in practice) |
| Maximum table size | 4 billion rows × 1000 columns |
| Maximum RAC nodes | 100 nodes |
| Maximum PDBs per CDB | 4,096 pluggable databases |
3. Converged Database
Unlike specialised databases, Oracle is a converged database — one engine for multiple data models:
- Relational — traditional SQL tables
- JSON — document store with SQL and REST access
- Graph — property graph queries with PGQL
- Spatial — geospatial data and location analytics
- Text — full-text search with Oracle Text
- Vector — AI Vector Search for similarity queries (23ai)
4. Autonomous Capabilities
Oracle Autonomous Database automates:
- Tuning — machine learning optimises queries automatically
- Patching — security patches applied without downtime
- Scaling — compute and storage scale up/down on demand
- Backup — automatic daily backups with point-in-time recovery
Editions
| Edition | Use Case |
|---|---|
| Express Edition (XE) | Free, limited to 2 CPUs, 2 GB RAM, 12 GB data |
| Standard Edition 2 (SE2) | Small to mid-size workloads, up to 2 sockets |
| Enterprise Edition (EE) | Full features, unlimited scaling |
| Enterprise Edition + Options | RAC, Partitioning, Advanced Security, etc. |
Oracle Database XE is the best way to get started — it is free to download, develop, and deploy.
How Oracle Database Compares
| Feature | Oracle | PostgreSQL | SQL Server | MySQL |
|---|---|---|---|---|
| Licence | Commercial (XE free) | Open source | Commercial (Express free) | Open source / commercial |
| Max DB size | Unlimited | Unlimited | 524 PB | 256 TB |
| RAC (clustering) | Yes | No (third-party) | Always On AG | Group Replication |
| Multitenant | Yes (CDB/PDB) | No | No | No |
| PL/SQL | Yes | PL/pgSQL (similar) | T-SQL | Stored procedures |
| Converged data models | JSON, Graph, Spatial, Text, Vector | JSON, limited | JSON | JSON |
Key Terminology
| Term | Definition |
|---|---|
| Instance | The memory structures (SGA) and background processes that access a database |
| Database | The physical files on disk — datafiles, redo logs, control files |
| Schema | A collection of database objects (tables, views, indexes) owned by a user |
| Tablespace | A logical storage container that groups related datafiles |
| PDB | Pluggable Database — an isolated database within a Container Database |
| CDB | Container Database — the root container that holds one or more PDBs |
| SID | System Identifier — a unique name for an Oracle instance on a host |
| Service Name | A logical name for connecting to a database, often mapped to a PDB |
Summary
Oracle Database is a powerful, feature-rich RDBMS trusted by enterprises worldwide. Its combination of reliability, scalability, converged multi-model support, and autonomous capabilities makes it a leading choice for mission-critical applications. Whether you are building a small prototype with Oracle XE or running a global financial system on Enterprise Edition with RAC, Oracle Database provides a consistent, robust platform.
In the next lesson, we will explore Oracle Database architecture — the internal components that make it all work.