Feedback

Feedback to trainingforit.co.uk


Site comment Site ratings
Email (optional)

Content

Design

Ease of use

Overall

Oracle Database 10g DBA Performance & Tuning

Summary
Length:
4 days
Price:
1,495 GBP excl. VAT
Training Provider:
StayAhead Training plusStayAhead Training
Location:
Training Method:
Startdate:  
London: 26/03/2012, 21/05/2012

About Oracle Database 10g DBA Performance & Tuning

Oracle Database 10g DBA Performance & Tuning Course Overview
Delegates attending the Oracle Database 10g DBA Performance & Tuning course will be introduced to the main concepts of Oracle performance tuning and will gain practical experience in analyzing and tuning database performance.  They will learn to identify tuning contentions and be able to take corrective action.  By the end of the course, delegates will be able to:
  • use different tuning methodologies
  • use the database advisors to proactively tune a database
  • use AWR tools to tune a database
  • detect and tune common database performance problems
  • use Enterprise Manager to monitor an Oracle database

Skills Gained
The delegate will practice:
  • Tuning goals and methodology
  • Planning initial database configuration
  • Tuning database applications for optimal performance
  • Identifying and resolving common tuning problems
  • Using diagnostic sources
  • Logging a SR with Oracle support
  • Managing statistics
  • Structuring SQL statements for performance
  • Using the SQL optimizers
  • Using Indexes effectively
  • Examining the execution plan of a SQL statement using Explain Plan
  • Examining the efficiency of SQL statements using SQL trace and autotrace
  • Using table joins
  • Monitoring statistics and wait events
  • Using metrics, alerts and baselines
  • Using statspack
  • Using the Automatic Workload Repository
  • Tuning the SGA and Shared Pool
  • Tuning the data block buffers
  • Using Automatic Memory Management
  • Setting the PGA and temporary space
  • Tuning checkpoint and redo logs
  • Managing disk I/O
  • Managing undo information
  • Tuning block space
  • Improving performance with materialized views
  • Using parallel execution

Who will the Course Benefit?
This Oracle Database 10g DBA Performance & Tuning course is suitable for database administrators, application developers and technical support staff who are required to monitor and tune an Oracle Database 10g.

Course Objectives
The objective of the Oracle Database 10g DBA Performance & Tuning course is to provide the skills needed to monitor and tune an Oracle Database 10g.

Requirements
Delegates who wish to attend the Oracle Database 10g DBA Performance & Tuning course should have a working knowledge of SQL*Plus, PL/SQL and Oracle Database Administration.  This can be obtained by attendance on the Oracle SQL and Oracle Database 10g DBA Part I courses.  Some operating system experience is essential.

Knowledge of PL/SQL is desirable.  Some operating system experience is essential.

Pre-Requisite Courses
  • Oracle SQL


  • Oracle Database 10g DBA - Part I




Follow-On Courses
  • Oracle Database 10g DBA Backup & Recovery with RMAN


  • Oracle Database 10g Release 2 Data Guard




NOTE: Course technical content is subject to change without notice.

Oracle Database 10g DBA Performance & Tuning Training Course
Course Contents - DAY 1
Course Introduction
  • Administration and Course Materials
  • Course Structure and Agenda
  • Delegate and Trainer Introductions

Session 1: INTRODUCTION TO ORACLE PERFORMANCE TUNING
  • Tuning Overview
  • Resolving Performance Problems
  • The Oracle Approach to Tuning
  • Items to Evaluate
  • Where to Look
  • Plan a Routine Monitoring Regime
  • Build a New Database for Performance
  • Tune an Existing Database for Performance
  • Set Suitable Goals

Session 2: DIAGNOSING PROBLEMS
  • Diagnostic Sources
  • Log a Performance Service Request (SR)
  • Tips for Avoiding Problematic Queries

Session 3: TOOLS FOR EVALUATING SQL STATEMENTS
  • Overview of SQL Statement Tuning
  • Explain Plan and autotrace
  • SQL Trace and the tkprof Program
  • Interpreting SQL Trace

Session 4: THE OPTIMIZER
  • The SQL Optimizer
  • The Rule Based Optimizer
  • The Cost Based Optimizer
  • The Analyze Command
  • Manage Statistics with DBMS_STATS

Session 5: INDEXES
  • Index Overview
  • B*Tree Indexes
  • Access Paths with Indexes
  • Index Scans
  • Conditions which Stop Indexes Being Used
  • Parameters Affecting Optimizer Index Choice

Oracle Database 10g DBA Performance & Tuning Training Course
Course Contents - DAY 2
Session 6: ADVANCED INDEXES
  • Bitmap Indexes
  • Key Compressed Indexes
  • Index Organized Tables
  • Function-Based Indexes
  • Descending Indexes

Session 7: TYPES OF TABLE JOINS
  • Joining Tables
  • Nested Loops Join
  • Cluster Join and Hash Join
  • Anti Join and Semi Join
  • Outer Join
  • Star Join

Session 8: METRICS, ALERTS AND BASELINES
  • System Generated Alerts
  • Threshold Based Alerts
  • Event Based Alerts
  • Retrieve Threshold Information
  • View Alert Data
  • Manage Metrics Using EM
  • Blackouts
  • Baselines and Adaptive Thresholds

Session 9: STATSPACK
  • Overview Of Statspack
  • Statspack Architecture
  • Install Statspack
  • Adjust the Statspack Collection Level
  • Create, View and Delete Snapshots
  • Generate a Report
  • Analyze the Reports to Generate an Execution Plan for a Given SQL Statement
  • Resolve Wait Events
  • Remove Statspack from the Database

Session 10: AUTOMATIC WORKLOAD REPOSITORY
  • Automatic Workload Repository
  • Create Snapshots and Compare Snapshots
  • Use Baselines
  • Generate AWR Reports
  • Compare AWR Periods Reports
  • Generate Active Session History (ASH) Report
  • Automatic Database Diagnostic Monitor (ADDM)
  • Generate and Analyze ADDM Reports

Session 11: REACTIVE TUNING
  • Use Enterprise Manager to Identify Common Problems
  • Eliminate Operating System Contentions

Oracle Database 10g DBA Performance & Tuning Training Course
Course Contents - DAY 3
Session 12: TUNING THE SHARED POOL
  • Overview of the Shared Pool
  • Alter and Tune the Shared Pool Size
  • Tune the Data Dictionary Cache and the Library Cache
  • Shared Pool Advisory Statistics
  • Pin objects in the Shared Pool
  • Cursor Sharing
  • Using the Large Pool
  • Latches and Mutexes

Session 13: TUNE THE BUFFER CACHE
  • Memory Structures
  • Data Block Buffer Pool
  • Multiple Buffer Caches
  • Manage Free Buffers
  • Establish the Buffer Pool Efficiency
  • Cache Tables in the Buffer Pools
  • Common Performance Issues and the Buffer Cache

Session 14: AUTOMATIC MEMORY MANAGEMENT
  • Automatic Memory Management
  • Automatic Shared Memory Management
  • Memory Allocation Advisors
  • The Memory Advisor
  • The Shared Pool and Buffer Cache Advisors

Session 15: TUNE PGA AND TEMPORARY SPACE
  • PGA Overview
  • Automatic PGA Mode
  • Configure the PGA for a New Instance
  • The Program Global Area Advisor
  • PGA Management Data Dictionary Views
  • Tune the PGA_AGGREGATE_TARGET
  • SQL Operations that Use Sorts
  • Sorting to Disk
  • Multiple Temporary Tablespaces
  • Allocate Temporary Disk Space for Sorting
  • Temporary Tablespace Shrink
  • Data Dictionary Views and Sort Segments

Session 16: CHECKPOINT AND REDO TUNING
  • Checkpoint and Redo Issues
  • Instance Recovery Performance Tuning
  • Redo Log File Size Advisor
  • Size the Redo Log Buffer
  • Set Multiple Database Writers

Oracle Database 10g DBA Performance & Tuning Training Course
Course Contents - DAY 4
Session 17: TUNE I/O
  • Database I/O Management
  • Layout the Files Using OS or Hardware Striping
  • Manually Distribute Files to Reduce I/O Contention
  • When to Separate Files
  • Sample Configurations
  • Select the Data Block Size
  • Synchronous I/O Benefits
  • FILESYSTEMIO_OPTIONS Parameter
  • Automatic Storage (ASM) Monitoring

Session 18: USE ORACLE BLOCKS EFFICIENTLY
  • Determine the Database Block Size
  • Tablespace, Table and Index Storage Parameters
  • Automatic Segment Space Management
  • Detect and Resolve Freelist Contention
  • Rebuild Tables and Indexes
  • The DBMS_SPACE Package
  • Row Migration
  • Chained Rows
  • Bigfile Versus Smallfile Tablespaces
  • Extended ROWID Format
  • Convert from Dictionary Managed Tablespaces
  • Convert to Automatic Segment Space Management

Session 19: MATERIALIZED VIEWS
  • Overview of Materialized Views
  • Materialized View Creation
  • Materialized View Refresh
  • Query Rewrite
  • Materialized View Data Dictionary Views

Session 20: PARALLEL EXECUTION
  • Overview of Parallel Execution
  • Enabling and Using Parallel Execution
  • The Degree of Parallelism
  • SQL Hints
  • Restrictions on the Use of Parallel Execution
  • Dictionary Views on Parallel Execution
  • Specific Automatic Parallel Query Optimization
  • Nologging Options

Session 21: TRACING SERVICES
  • End to End Tracing
  • Enable and Disable Tracing
  • Check for Tracing Enabled
  • The trcess Utility
  • Session Based Tracing
  • Enable and View SQL Tracing with Enterprise Manager
  • Analyze Trace Results

Continuing studies

Follow on courses: Oracle Database 10g DBA Backup & Recovery with RMAN, Oracle Database 10g Release 2 Data Guard

Expenses

£1,495.00

About StayAhead Training

technical it training

SQL, Oracle, UNIX and Linux experts

StayAhead Training are recognised as one of the top 50 IT Training organisations in the UK and the first choice provider of UNIX, Linux, MySQL and Oracle training courses for many of the UK's most prominent organisations.

StayAhead Training was established in 1992 and now have training centres in London, Birmingham, Manchester, Leeds, Edinburgh and Bristol. Because of this, StayAhead are able to offer a large range of scheduled, tailored and onsite training. Independent of where you are based, StayAhead can help you and your firm's IT requirements be reality.

StayAhead IT Training works with some of the largest names in the IT training industry to provide courses on behalf of Parity Training, Global Knowledge, New Horizons and many more.

unix, linux, oracle, sql, javaSpecialist IT training

StayAhead Training have a formidable reputation for quality and expertise within the UNIX, Oracle, Linux and MySQL arena and enjoy an enviable position in the UK by being amongst the top IT Technical training organisations.

The UNIX curriculum not only covers standard UNIX but includes a range of Solaris, AIX, HP-UX, Linux, SUSE, LPI & Red Hat Linux training. The Oracle curriculum also has depth with courses available for DBAs, Developers and Designers. If certification is important to you then again we do not disappoint taking delegates to the level required to take the examinations in Solaris, Red Hat, SUSE, LPI, MySQL, Oracle Forms Developer and Oracle DBA. With the Oracle e-business suite growing in popularity a range of Oracle Financials courses are also available.

StayAhead's training flexibility comes from developing their own courses that include high quality course material, written not only to support the learning process, but can also act as a helpful reference guide on the delegates return to work.

In-house IT training

In addition to the public schedule of courses provided, StayAhead offer all courses in-house at a client's site, or at a StayAhead location. All courses can be tailored to meet our clients' specific needs. For courses at the client's site StayAhead can provide all the necessary hardware and software.

StayAhead's focus on IT training

StayAhead understands the best approach for such technical IT training is always to be enthusiastic, business-like, informal yet professional. Whether delegates attend a StayAhead Training scheduled course or an on-site course, each event is approached in a professional manner.

StayAhead's style of delivery is designed to foster the development of learning. Instructor led tutorials are followed by practical exercises. The style is experiential allowing delegates to take ownership and solve problems for themselves. Research shows that the pace of learning is greatly accelerated when delegates are shown HOW to solve their problems rather than just why they should.

specialist it training


plus Show all courses with StayAhead Training

Request information - obligation free

Get more information from StayAhead Training by filling out the following form. This is a free service for you and the course provider to help you find the most suitable training.
To request information from StayAhead Training, please fill out the following details:
* =  Required field
Email Address*
First Name*
Last Name*
Company
Position
Town/City*
Telephone*
Start date
Number of participants
Message*
Rules

Contact information for StayAhead Training

StayAhead Training

6 Long Lane, Barbican
EC1A 9HF London

Phone no: 020 7600 6116
www.stayahead.com

More Information
Request Information
To request information from Oracle Database 10g DBA Performance & Tuning, please fill out the following details:

What happens now?
Write a course review
Have you studied » Oracle Database 10g DBA Performance & Tuning at » StayAhead Training? Share your experience & help others to pick the right course. Set grades (1-5) where 1= very poor & 5 = excellent.
V. Poor | Poor | OK | Good | Excellent
Trainer / Provider
Venue / Facilities
Course Materials
Networking with other delegates

Do you recommend the provider:


Need help finding the right course?

  
By submitting your e-mail, you become a member of Trainingforit.co.uk