title
Please take a moment to fill out this form. We will get back to you as soon as possible.
All fields marked with an asterisk (*) are mandatory.
Oracle Database 11g R2: Architecture & Internals
Duration
1.5 Days
Course
DBOR-931
Available Formats
Classroom Training, Online Training
Course Description
Overview
This Oracle Database 11g R2: Architecture & Internals course is designed to provide students with an understanding of the architecture and internal mechanisms which operate within the database. The purpose training course is to reveal the underlying architecture of the Oracle database environment. It is also intended to be 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.
Objectives
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 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.
- Recognize 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.
- 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 which one may find within the logical application database.
- Understand the schema and ownership context in which logical database objects reside.
- Discern the editions context in which database objects can exist in different forms and how hot application upgrades are supported by database editions.
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, and Data center support engineers.
Prerequisites
- ORACLE DATABASE 11G R2: ADVANCED PL/SQL PROGRAMMING & TUNING (DBOR-922)
- ORACLE DATABASE 11G R2: SQL TUNING (DBOR-932)
- ORACLE DATABASE 11G R2: PERFORMANCE TUNING
- ORACLE DATABASE 11G R2: NEW & ADVANCED FEATURES FOR DEVELOPERS
Topics
- ABOUT enterprise architectures
- ABOUT parallelization
- SMP
- THE database server stack
- THE database server software
- V$VERSION
- DATABASE instance configurations
- ABOUT the SGA
- USING v$sga_dynmaic_components
- ABOUT the PGA
- MANAGING instance memory
- INSTANCE background processes
- SQL execution processes
- USING V$SESSION
- ABOUT the pga
- SQL statement execution
- APPLICATION database objects
- SCHEMA & ownership context
- EDITIONS context & redefinition
- ABOUT the database files
- DATABASE server parameter file
- CONTROL files
- ALERT log & trace files
- TABLESPACES & data files
- AUTOEXTEND options
- ABOUT temporary segments
- ABOUT index segments
Related Courses
-
Oracle Database 11g R2 SQL Complete
DBOR-917- Duration: 5 Days
- Delivery Format: Classroom Training, Online Training
- Price: 3,500.00 USD
-
Oracle Database 11g: Advanced PL/SQL Programming & Tuning
DBOR-922- Duration: 5 Days
- Delivery Format: Classroom Training, Online Training
- Price: 3,500.00 USD
Self-Paced Training Info
Learn at your own pace with anytime, anywhere training
- Same in-demand topics as instructor-led public and private classes.
- Standalone learning or supplemental reinforcement.
- e-Learning content varies by course and technology.
- View the Self-Paced version of this outline and what is included in the SPVC course.
- Learn more about e-Learning
Course Added To Shopping Cart
bla
bla
bla
bla
bla
bla
Self-Paced Training Terms & Conditions
??spvc-wbt-warning??
??group-training-form-area??
??how-can-we-help-you-area??
??personalized-form-area??
??request-quote-area??
Sorry, there are no classes that meet your criteria.
Please contact us to schedule a class.
STOP! Before You Leave
Save 0% on this course!
Take advantage of our online-only offer & save 0% on any course !
Promo Code skip0 will be applied to your registration
Nothing yet
Purchase Information
??elearning-coursenumber?? ??coursename??
View Cart