Oracle Database 10g: Architecture For Developers Course

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.

Upon completion of this course, the participant will be able to:
> 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

Oracle Database Server Architecture
Oracle Enterprise Manager (OEM)
OEM Console

Application Architectures
2-Tier Traditional Client/Server
3-Tier Traditional Client/Server
3-Tier Traditional Intranet Or Internet
The Oracle Database Server
How Does A SQL Statement Execute?
What is the data dictionary?
Database users & schemas
SYS Schema Illustrated
OEM Security Manager, Users
Data Dictionary, DBA_USERS

Understanding Database Objects
Which Database Objects Exist?
OEM Schema Manager, Schema Objects
Data Dictionary, DBA_Objects
OEM Schema Manager, Tables (General Tab)
Data Dictionary, DBA_Tables
Data Dictionary, User_Tab_Columns
OEM Schema Manager, Tables (Constraints Tab)
Data Dictionary, DBA_Constraints
Data Dictionary, DBA_Cons_Columns
OEM Schema Manager, Sequences
Data Dictionary, DBA_Sequences

Instance & User Memory Structures
IFILE Parameter
OEM Instance Manager, Initialization Parameters
Single Instance
Concurrent Instances And Databases, Same Server
Multiple Instances For One Database, Same Server
Oracle Real Application Clusters
Multiple Instances For One Database, Clustered Servers
System Global Area (SGA)
How The Java Pool Is Used
Parameters Which Determine SGA Size
About Oraclei Buffer Cache & Subcaches
SGA Size

Instance & User Processes
Which Processes Are Executing?
Instance Background Processes
Instance Background System Processes Illustrated
DBWR & LGWR Processes
Checkpoints And CKPT Process
SMON & PMON Processes
ARCH Process
OEM Instance Manager, Background Process List
Oracle Jserver Instance
Oracle Jserver Instance Illustrated
SQL EXECUTION
PGA & Instance
Data Dictionary, V$SESSION
OEM Instance Manager, Sessions

Data Files, Data Segments
Which Files Are Used By The Database?
Data Files & The Physical Storage Hierarchy
Understanding Tablespaces
Understanding Data Files
Understanding Segments
Understanding E_Derst
Understanding Database Blocks
Pctfree/Pctused
Understanding The Row Structure
Understanding R_D
Rowid_To_Restricted()
Rowid_To_Extended()

Data Files, Non-Data Segments
The Non-Data S_Ta
Indexes & Index Segments
Bitmap Vs B-Tree Index Scenario
DBA_Indexes
DBA_Ind_Columns
Temporary Segments, Rollback Segments
DBA_Segments, DBA_Rollback_
V$Rollname and V$Rollstat
Non-Data Files

Oracle Database 10g: Introduction to SQL