Oracle Database 11g R2: Architecture & Internals

Request more details:

Description:
Success in database administration and tuning, or in the development of database applications, depends upon having a sufficient understanding of the architecture and internal mechanisms which operate within the database. Without such an understanding, one could implement such things as structural changes, performance tuning adjustments and other modifications to the environment which could actually be counterproductive. The purpose of this unique and popular training course is to reveal the underlying architecture of the Oracle database environment. This course is also intended to be of help to information technology (IT) managers and executives who require an understanding of the technology upon which they and their staff rely.
This architectural discussion will be much more than just a presentation of theoretical concepts. After explaining in logical terms the architectural component under consideration, this course module will frequently show the component as it is actually rendered by the Enterprise Manager graphical interface for database administrators. At other times this course will use the SQL command‐line interface to explain the characteristics of the architectural component being discussed.
Furthermore, while other modules within this curriculum are focused on the actual administration of these database components, in some cases we will demonstrate within this course how one creates or configures some of these elements under discussion.
Prerequisites:
• RELATIONAL DATABASE DESIGN & DATA MODELING
• ORACLE DATABASE 11G R2: SQL FUNDAMENTALS – COMPLETE LIBRARY
• ORACLE DATABASE 11G R2: THE COMPLETE INSTALLATION GUIDE FOR LINUX & WINDOWS
THE BROADER ORACLE ENTERPRISE ARCHITECTURE:
• ABOUT ENTERPRISE ARCHITECTURES
• ABOUT PARALLELIZATION
• SMP
• THE DATABASE SERVER STACK
• THE DATABASE SERVER SOFTWARE
• V$VERSION
EXPLORING THE ORACLE DATABASE INSTANCE:
• DATABASE INSTANCE CONFIGURATIONS
• ABOUT THE SGA
• Using V$SGA_DYNAMIC_COMPONENTS
• ABOUT THE PGA
• MANAGING INSTANCE MEMORY
EXPLORING THE INSTANCE PROCESSES:
• INSTANCE BACKGROUND PROCESSES
• SQL EXECUTION PROCESSES
• Using V$SESSION
• About The PGA]
•SQL STATEMENT EXECUTION
EXPLORING LOGICAL STORAGE: DATABASE OBJECTS:
• APPLICATION DATABASE OBJECTS
• SCHEMA & OWNERSHIP CONTEXT
• EDITIONS CONTEXT & REDEFINITION
EXPLORING PHYSICAL STORAGE: DATABASE FILES:
• ABOUT THE DATABASE FILES
• DATABASE SERVER PARAMETER FILE
• CONTROL FILES
• ALERT LOG & TRACE FILES
EXPLORING PHYSICAL STORAGE: TABLESPACES:
• TABLESPACES & DATA FILES
• AUTOEXTEND Options
• ABOUT TEMPORARY SEGMENTS
• ABOUT INDEX SEGMENTS