Oracle Database 10g: Architecture for Developers

Request more details:

Description:
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.

View other Oracle Courses available
Prerequisites:
Oracle Database 10g: Introduction to SQL Complete library and Oracle Database 10g: Introduction to PL/SQL Complete library
Objective Coverage: :
-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.
ABOUT THE ORACLE10G GRID-BASED TECHNOLOGY:
SMP
About the Oracle 10g Database
The Enterpirse Manager Database Interface
THE ORACLE DATABASE ARCHITECTURE:
General Database Architecture
Oracle_Base
Oracle_Home
Database Instance Memory Architecture
DATABASE INSTANCE PROCESS ARCHITECTURE:
Instance Background Processess
SQL Execution Processes
DATABASE STORAGE ARCHITECTURE:
About Tablespaces
More About Temperary Tablespaces
More About Permanent Tablespaces
More about the Sysaux Tablespace
About Undo Space Management
More About Data Files
More Oracle-Managed Files (OMF)
DATABASE SECURITY & INTEGRITY:
Database System Privileges
Database Objective Privileges
Database Accounts
About Role Based Security
With Admin Option & system Privileges
With Grant Option and System Privileges
About Latches & Locks
ORACLE NET SERVICES ARCHITECTURE:
About Oracle Net Services
Oracle Net Services and 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 and V$Dispatcher_Config
V$Queue
BACKUP & RECOVERY ARCHITECTURE:
About Database Back Up & 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: