WA1383 Oracle Database 10g: Architecture for Developers
Audience
Oracle developers
Description
This is a special adaptation of the database architecture module normally presented to database administrators but customized for the benefit of developers. With a series of in-depth lectures developers are acquainted with the internal architecture of the Oracle database, including memory structures, data file structures, block and row internals. 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.
Course Prerequisites

Mandatory prerequisites for this course are the following courses:

• The course Oracle Database 10g: Introduction to SQL - Complete Library
• The course Oracle Database 10g: Program With PL/SQL - Complete Library

Course Objectives:
At Course Completion

• Explain the database memory structures, including the SGA and the shared pool
• Explain the configurations possible for Oracle instances
• Explain the structure of tablespaces, data files, extents, blocks and rows
• Explain the structure of tables and indexes
• Explain the role of redo log files, redo log buffers and rollback segments

Suggested Next Course:
The course Oracle Database 10g: SQL Tuning
Duration:
Two days.
More Information
Schedule this course
Course Outline
Download this page as a word document