Oracle Training Oracle Support Development Oracle Apps

 
 Home
 E-mail Us
 Oracle Articles
New Oracle Articles


 Oracle Training
 Oracle Tips

 Oracle Forum
 Class Catalog


 Remote DBA
 Oracle Tuning
 Emergency 911
 RAC Support
 Apps Support
 Analysis
 Design
 Implementation
 Oracle Support


 SQL Tuning
 Security

 Oracle UNIX
 Oracle Linux
 Monitoring
 Remote s
upport
 Remote plans
 Remote
services
 Application Server

 Applications
 Oracle Forms
 Oracle Portal
 App Upgrades
 SQL Server
 Oracle Concepts
 Software Support

 Remote S
upport  
 Development  

 Implementation


 Consulting Staff
 Consulting Prices
 Help Wanted!

 


 Oracle Posters
 Oracle Books

 Oracle Scripts
 Ion
 Excel-DB  

Don Burleson Blog 


 

 

 


 

 

   

Oracle Technical Architecture for Systems Engineers Training Course

A three day on-site Oracle Technical Architecture, best practices & tuning class
2007-2016 by Burleson Corporation

 

This course is taught at your Company site with up to 20 students. 

Click here for on-site course prices

Optional supplemental mentoring

 

   
Key Features

* Learn the history & evolution of Oracle database management and Understand the Oracle "culture".

* Learn how to deploy high performance storage management devices with Oracle.

* See how very large Oracle shops manage storage and server resources.

* See how replication addresses the problem of growing workloads.

* Understand Oracle replication and disaster recovery approaches.

* Understand optimal Oracle configuration for high performance.

* Learn Oracle best practices for Oracle configuration and management.

* See when and how to apply solid-state disk to Oracle storage architectures.

* See proven techniques for monitoring I/O throughput and finding bottlenecks.

* Understand how to verify I/O bottlenecks and predict throughout improvements from high speed solutions.

* Understand the common causes of performance problems and see how data caching improves access speed.

* Understand proven techniques for Oracle health checks.

* Get a management-level overview of Oracle Technical Architecture, Performance Tuning and Oracle best practices.

  

Course Description

This course is designed for practicing Systems Engineers with basic familiarity with database management who seek to understand Oracle technical history and evolution, Oracle technical architecture, Oracle performance tuning concepts and Oracle best practices.

All Systems Engineers are challenged to understand the Oracle technical architecture and understand how to employ Oracle best practices for configuration and management of very large Oracle databases.

Further, Oracle SE's must be able to quickly and accurately interact with Oracle technical support personnel for problem resolution and patch application.

All Oracle databases are I/O intensive and the goal of Oracle tuning is to retrieve the required data with a minimum of disk access.  For the SE, this involves understanding the interface between the database software and the operating system and seeing how to monitor Oracle for transient disk I/O bottlenecks.

 

Book Required

   
  • Oracle Disk I/O Tuning
        ISBN: 0974599344
  • Oracle RAC & Grid tuning with solid state disk 
        ISBN: 0976157357
  • Oracle Silver Bullets
        ISBN: 0975913522

 

Audience

This course is designed for Systems Engineers and Systems Administrations who are challenged to help manage Oracle systems in very large and high workload environments.

The course assumes a basic knowledge of database management and administration, relational database concepts, and basic disk storage architecture.

     

Curriculum Design

This Technical Architecture training was designed by Donald K. Burleson.  Author of more than 30 database books, Burleson was chosen by Oracle Press to write five authorized editions, including three Oracle Tuning books. Burleson has extensive Oracle tuning experience and wrote the book "Oracle Tuning: The Definitive Reference".



Oracle Technical Architecture for Systems Engineers
Training Course

A three day on-site Oracle architecture, tuning and best practices course
Copyright 2007-2016 by Burleson Corporation
 
Syllabus
 
Day One
Overview of the Oracle Technical Architecture
 
1 - The history & evolution of Oracle database management.
 
2 - The history of Oracle architectures
 
     - Oracle 7
     - Oracle 8 - Object orientation
     - Oracle 8i - The internet database
     - Oracle 9i - Infinite scalability and 64-bit support
     - Oracle 10g - The RAC and grid database

3 - Overview of the Oracle Technical Architecture
 
     - The Oracle SGA
     - Oracle storage (ASM, RAID)
     - Oracle disk I/O sub-system (data buffers, KEEP pool)
     - Oracle monitoring tools (OEM, STATSPACK, AWR)
 
4 - Managing Oracle disk storage
 
     - Oracle and RAID 10
     - Oracle disk I/O architectures (SAN, NAS)
     - SSD for Oracle
 
5 - Managing Oracle Server resources
 
     - Oracle top-5 timed events and bottleneck identification
     - Proactive vs. reactive server management
        (predictive modeling with AWR vs. v$ and ASH tables)
     - Using Oracle tools for finding server-side and network constraints
 
6 - Deploying storage solutions for Oracle
 
     - Applying SSD for I/O bottlenecks
     - The transient nature of disk I/O contention
 
Day Two
Oracle performance management and best practices
 
1 - Areas of Oracle performance management monitoring
 
     - Oracle server environment
     - Oracle memory (SGA)
     - Oracle data file issues (freelists, maxtrans)
     - Oracle object tuning (cluster tables, index rebuilding)
     - Overview of STATSPACK, AWR and ASH
 
2- Tuning the Oracle external server, disk and network environment

This section will teach students about external influences on Oracle performance, how to measure them, and how to ensure that the external environment is properly configured for Oracle. Students will learn how to take advantage of all the UNIX-based tools for monitoring, configuring, and tuning the external environment. The course also covers tuning issues related to the operating system, tuning for effective CPU usage, reorganizing tables to improve I/O performance and more.

3 - Monitoring server resource bottlenecks

This section will focus on identifying and correcting external influences including RAM memory shortages, disk I/O bottlenecks, and CPU shortages.  The external environment will be monitored using the vmstat and iostat utilities.  This section will discuss the iterations of recommendations relating to environmental tuning such as OS dispatching priorities, swap space allocation, and other OS-specific issues. 

  • vmstat utility – Interpreting the runqueue, page-in and the CPU metrics.

  • iostat utility – Using the iostat utility to determine disk I/O access patterns and I/O bottlenecks.

4 - Oracle replication and workload management
This section will explore Oracle replication with RAC and Streams and explain the ramifications of replication versus database links for distributed data, failover, workload balancing and disaster recovery.
5 - Oracle Memory (SGA) tuning
  • Data Buffer management - Buffer management issues will include the performance of Oracle with various values of db_block_size and the proper settings for db_block_buffers.  This section will also look at allocation of the DEFAULT, KEEP and RECYCLE pools.
     

  • Shared pool issues – This section will discuss the management of the components of the shared pool with a focus on the management of activity in the library cache.
     

  • Sorting issues – This section will describe the management of the sort_area_size parameter and how to determine the optimal setting for disk versus memory sorting.

6 - Oracle configuration best practices
 
     - Oracle SAME
     - Oracle OFA
     - Oracle standards and best practices for the DBA
 
 
Day Three
Oracle Monitoring, health checks and executive summary
 
1 - Proactive data monitoring for predictive management
This section will introduce the Oracle data repository (STATSPACK & AWR), and show commonly-used scripts for locating bottlenecks.  This section will also introduce the TMS utility www.statspackanalyzer.com and show how to interpret monitoring results.
2 - Monitoring for performance signatures
This section show how to identify repeating performance trends and how to apply just-in-time resources for impending bottlenecks.
3 - Monitoring for storage bottlenecks
This section will introduce a number of scripts specifically geared toward to locating transient I/O bottlenecks with a focus on interpreting the script results.
4 - Conducting an Oracle Health Check
All Oracle databases become sub-optimal as a function of usage and this section covers the highlights of an Oracle health check, what is checked, and why it's important to overall database management.
5 & 6 - Executive summary for IT managers
This will teach the SE to present an encapsulation of the course concepts for presentation to senior IT management.  The emphasis will be on drawing analogies and illustration for an "in a nutshell" overview of Oracle technical architecture, performance tuning, monitoring and best practices.


 

 

��  
 
 
Oracle Training at Sea
 
 
 
 
oracle dba poster
 

 
Follow us on Twitter 
 
Oracle performance tuning software 
 
Oracle Linux poster
 
 
 

 

Burleson is the American Team

Note: This Oracle documentation was created as a support and Oracle training reference for use by our DBA performance tuning consulting professionals.  Feel free to ask questions on our Oracle forum.

Verify experience! Anyone considering using the services of an Oracle support expert should independently investigate their credentials and experience, and not rely on advertisements and self-proclaimed expertise. All legitimate Oracle experts publish their Oracle qualifications.

Errata?  Oracle technology is changing and we strive to update our BC Oracle support information.  If you find an error or have a suggestion for improving our content, we would appreciate your feedback.  Just  e-mail:  

and include the URL for the page.


                    









Burleson Consulting

The Oracle of Database Support

Oracle Performance Tuning

Remote DBA Services


 

Copyright © 1996 -  2017

All rights reserved by Burleson

Oracle ® is the registered trademark of Oracle Corporation.

Remote Emergency Support provided by Conversational