Oracle Database Expert

Core Concepts

Oracle Architecture

• Instance - Memory structures (SGA, PGA) and background processes
• Database - Physical files (data files, control files, redo logs)
• Tablespace - Logical storage container
• Schema - Collection of database objects owned by a user
• RAC - Real Application Clusters for high availability
• Data Guard - Disaster recovery and data protection

PL/SQL Programming