ORA10g002 - Oracle Database 10g: Architecture For Developers

Course ORA10g002

Table of Contents

Introduction
Audience
At Course Completion
Prerequisites
Certified Professional Exams
Student Materials
Course Outline

---

Introduction

This is a special adaptation of the database architecture module normally presented to database administrators but customized for the benefit of developers and technical managers. With a series of in-depth lectures students are progressively acquainted with the internal architecture of the Oracle database, including memory structures, data file structures, block and row internals, advanced manageability features and more. The objective is to provide developers with the skills needed to properly build and tune applications for optimum performance compatible with the architecture of the Oracle database.

Return to Top

---

Audience

The target audience for this course is senior Oracle database developers. Although these will rely upon database administrators for the day-to-day administration of the database, their understanding of the architecture is critical. This course will also be of interest to management and others who require an in-depth understanding of the database architecture without a corresponding knowledge of how to perform the actual administration tasks.

Return to Top

---

At Course Completion

At the end of this course, the student will be able to explain the:

• The enterprise-wide Oracle grid-based architecture and how this relates to individual databases and their architecture.
• The Oracle database and other tightly integrated related technologies, such as Oracle Net Services, Oracle Enterprise Manager and others.
• The internal architecture of an Oracle database. This includes the memory structures, process structures and physical data structures.
• Drilling deep into the physical storage architecture of the data structures, including
tablespaces, data files, segments, extents, partitions, blocks, and row internals.
• Database security and integrity components.
• Advanced architecture components, such as shared servers, the manageability framework, and automatic storage management.
• Backup and recovery structures, including redo data and flashback database technology.

Return to Top

---

Prerequisites

It's recommended that you take the following two classes prior to this class:

• ORA10g008 - Oracle Database 10g: Introduction to SQL I
• ORA10g009 - Oracle Database 10g: Introduction to SQL II

Return to Top

---

Certified Professional Exams

No exam currently exists for this course.

Return to Top

---

Student Materials

The student kit includes a comprehensive workbook and other necessary materials for this class.

Return to Top

---

Course Outline

ABOUT THE ORACLE10G GRID-BASED TECHNOLOGY
• SMP
• ABOUT THE ORACLE10G DATABASE
• THE ENTERPRISE MANAGER DATABASE INTERFACE

THE ORACLE DATABASE ARCHITECTURE
• GENERAL DATABASE ARCHITECTURE
• ORACLE_BASE
• ORACLE_HOME
• DATABASE INSTANCE MEMORY ARCHITECTURE

DATABASE INSTANCE PROCESS ARCHITECTURE
• INSTANCE BACKGROUND PROCESSES
• SQL EXECUTION PROCESSES

DATABASE STORAGE ARCHITECTURE
• ABOUT TABLESPACES
• MORE ABOUT TEMPORARY TABLESPACES
• MORE ABOUT PERMANENT TABLESPACES
• MORE ABOUT THE SYSAUX TABLESPACE
• ABOUT UNDO SPACE MANAGEMENT
• MORE ABOUT DATA FILES
• ABOUT ORACLE-MANAGED FILES (OMF)

DATABASE SECURITY & INTEGRITY
• DATABASE SYSTEM PRIVILEGES
• DATABASE OBJECT PRIVILEGES
• DATABASE ACCOUNTS
• ABOUT ROLE-BASED SECURITY
• WITH ADMIN OPTION & System Privileges
• WITH GRANT OPTION & Object Privileges
• ABOUT LATCHES & LOCKS

ORACLE NET SERVICES ARCHITECTURE
• ABOUT ORACLE NET SERVICES
• ORACLE NET SERVICES & EM

ORACLE DATABASE SHARED SERVERS ARCHITECTURE
• ABOUT SHARED SERVERS
• MONITOR SHARED SERVERS
• V$SHARED_SERVER
• V$SHARED_SERVER_MONITOR
• V$SESSION
• V$CIRCUIT
• V$DISPATCHER & V$DISPATCHER_CONFIG
• V$QUEUE

BACKUP & RECOVERY ARCHITECTURE
• ABOUT DATABASE BACKUP & RECOVERY STRUCTURES
• REDO DATA
• FLASH RECOVERY AREA

DATABASE MANAGEABILITY

THE DATABASE MANAGEMENT FRAMEWORK

AUTOMATIC DATABASE DIAGNOSTIC MONITOR

METRICS & ALERT THRESHOLDS

ASM & THE BROADER DATABASE ARCHITECTURE

Return to Top