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.
Cost: Price on application
Duration: 1-2 Days
This course is not available as part of our public schedule but can be provided on a customised client specific basis.
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
THE DATABASE SERVER STACK
THE DATABASE SERVER SOFTWARE
EXPLORING THE ORACLE DATABASE INSTANCE:
DATABASE INSTANCE CONFIGURATIONS
ABOUT THE SGA
ABOUT THE PGA
MANAGING INSTANCE MEMORY
EXPLORING THE INSTANCE PROCESSES:
INSTANCE BACKGROUND PROCESSES
SQL EXECUTION PROCESSES
About The PGA]
SQL STATEMENT EXECUTION