Oracle Database Architecture

Description

In this course, you will :

• Learn about Oracle Database Architecture and Administration.

Syllabus :

• 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