Introduction
  • Introduction to Computing Architecture
  • Oracle Database Architecture Overview
  • Oracle Database and Instance Components
  • Oracle Instance Components
  • Oracle Database Files
  • What is the Listener?
  • SELECT STatement processing
  • DML Statement Processing
  • DDL Statement Processing
  • Instance Recovery
  • Redo Logs
  • Concurrent Transactions
  • Oracle Instance Startup
  • Oracle Instance Shutdown
  • Introduction to Real Application Clusters
  • Crash Recovery in Oracle RAC
  • How do applications Connect to the Database
  • Shared Server Configuration
  • Connection Pool
  • Connection Pool Optimization
  • Global Temporary Tables
  • Physical and Logical Structures
  • Different Types of Tablespaces
  • Read Consistency - Introduction
  • Read Consistency - Statement Level
  • System Change Number (SCN)
  • Read Consistency - Transaction Level
  • What are Data Blocks?
  • Structure of Data Blocks
  • Structure of a Row
  • Space Management
  • ROWID
  • User and Schema
  • User Profiles