Course Overview

This Oracle Database 11g R2: Architecture & Internals course is designed to provide students with an understanding of the architecture and internal mechanisms that operate within the database. The purpose of the training course is to reveal the underlying architecture of the Oracle database environment. It is also intended to help information technology (IT) managers and executives who require an understanding of the technology upon which they and their staff rely.

This course covers topics included in the certification tests. EXAM #1Z0-052 ORACLE DATABASE 11G: ADMINISTRATION I and EXAM #1Z0-514 ORACLE DATABASE 11G ESSENTIALS.

What you’ll learn

Upon completion of the Oracle Database 11g R2: Architecture & Internals course, students will be able to:

• Understand the broader Oracle enterprise architecture, including the client, middleware, and database tiers found within a multi-tiered enterprise environment.
• Comprehend key computing concepts such as parallelization, grid-based resource acquisition, and clusters.
• Recognize the role of database machines, such as the Exadata database computing machines and storage machines.
• Manage an in-depth exploration of the database architecture, including memory, process and data structures, and the composition of an Oracle database instance.
• Explain alternative modes of database operation, including dedicated server mode, shared server mode, and parallel execution, and how one selects the appropriate mode for each environment.
• Consider the role of the Shared Global Area (SGA) and the various memory caches and subcaches, which can be optionally configured within that space.
• Recognize the complementary role of the Program Global Area (PGA), also known as the Process Global Area.
• Discuss the role of the instance background processes, including those that are optional and those that can have additional instances optionally launched.
• Consider physical database storage structures such as tablespaces, data files, blocks, and the internal format of rows.
• Explain the alternative row-level storage option of hybrid columnar compression.
• Compare and contrast internal storage of data segments, B-tree, and bitmap index segments.
• Review all of the possible database object types that one may find within the logical application database.
• Understand the schema and ownership context in which logical database objects reside.
• Discern the edition’s context in which database objects can exist in different forms and how hot application upgrades are supported by database editions.