Home    |    Instructor-led Training    |    Online Training     
         
 
Courses
ADA
Adobe
Agile
AJAX
Android
Apache
AutoCAD
Big Data
BlockChain
Business Analysis
Business Intelligence
Business Objects
Business Skills
C/C++/Go programming
Cisco
Citrix
Cloud Computing
COBOL
Cognos
ColdFusion
COM/COM+
CompTIA
CORBA
CRM
Crystal Reports
Data Science
Datawarehousing
DB2
Desktop Application Software
DevOps
DNS
Embedded Systems
Google Web Toolkit (GWT)
IPhone
ITIL
Java
JBoss
LDAP
Leadership Development
Lotus
Machine learning/AI
Macintosh
Mainframe programming
Mobile
MultiMedia and design
.NET
NetApp
Networking
New Manager Development
Object oriented analysis and design
OpenVMS
Oracle
Oracle VM
Perl
PHP
PostgreSQL
PowerBuilder
Professional Soft Skills Workshops
Project Management
Rational
Ruby
Sales Performance
SAP
SAS
Security
SharePoint
SOA
Software quality and tools
SQL Server
Sybase
Symantec
Telecommunications
Teradata
Tivoli
Tomcat
Unix/Linux/Solaris/AIX/
HP-UX
Unisys Mainframe
Visual Basic
Visual Foxpro
VMware
Web Development
WebLogic
WebSphere
Websphere MQ (MQSeries)
Windows programming
XML
XML Web Services
Other
Oracle Database 11g R2: Architecture & Internals
Oracle Training Overview

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.


Oracle Training Objectives

This course is often used in combination with other advanced Oracle database administration or database developer courses to provide the prerequisite foundation in the architecture of the database. Major objectives covered within this training guide include:
  • Understanding the broader Oracle enterprise architecture, including the client, middleware and database tiers found within a multi-tiered enterprise environment.
  • Understand key computing concepts such as parallelization, grid-based resource acquisition and clusters.
  • Understanding the role of database machines, such as the Exadata database computing machines and storage machines.
  • An in-depth exploration of the database architecture, including memory, process and data structures, and the composition of an Oracle database instance.
  • Alternative modes of database operation, including dedicated server mode, shared servers mode, 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.
  • Consider the complimentary role of the Program Global Area (PGA), also known as the Process Global Area.
  • Discuss the role of the instance background processes, including those which are optional and those which can have additional instances optionally launched.
  • Consider physical database storage structures such as tablespaces, data files, blocks and the internal format of rows.
  • Consider 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 which one may find within the logical application database.
  • The schema and ownership context in which logical database objects reside.
  • The editions context in which database objects can exist in different forms and how hot application upgrades are supported by database editions.
Oracle Training Audience

The primary audiences for this course are:
  • Chief Information Officers (CIO) and other information technology management
  • Database administrators
  • Application designers and developers
  • Web server administrators
  • System administrators
  • Implementation specialists
  • Data center support engineers
Oracle Training Certification

This course covers topics included in the certification tests ORACLE DATABASE 11G: ADMINISTRATION I and ORACLE DATABASE 11G ESSENTIALS.

Oracle Training Prerequisites

Specific prerequisites for this course are the following titles, or equivalent experience:
  • RELATIONAL DATABASE DESIGN & DATA MODELING
  • ORACLE DATABASE 11G R2: SQL FUNDAMENTALS – COMPLETE LIBRARY
  • ORACLE DATABASE 11G R2: THE COMPLETE INSTALLATION GUIDE FOR LINUX & WINDOWS
Oracle Training Course duration

1-2 Days

Oracle Training Course outline

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

Please contact your training representative for more details on having this course delivered onsite or online

Training Outlines - the one stop shopping center for IT training.
© Training Outlines All rights reserved