Oracle Database 11g R2: SQL Tuning, Architecture & Internals

The "Architecture & Internals" volume will 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.

The "SQL Tuning" volume will equip database administrators and application developers to build efficient SQL statements and to tune database applications. When this effort is complemented by database server and PL/SQL application tuning, then a highly efficient application execution environment is created. One will learn about the internals of SQL statement execution, how to monitor the performance of such execution, and how one can influence the behavior of the database to achieve performance gains. This textbook is a mandatory reference for any database administrator or SQL database application developer.