Oracle9i Database: Performance Tuning training seminars presented by Netcom Learning register now on FindaSeminar.com

findaseminar logo balls FindaSeminar.com
event search registration and marketing services since 2002
Advanced Search
 
 

Oracle9i Database: Performance Tuning  

 Email information about this seminar Oracle9i Database: Performance Tuning by Netcom Learning to yourself your manager or associates Email this event... View and register for other training seminars like Oracle9i Database: Performance Tuning by Netcom Learning on FindaSeminar.com Find similar training.. Find and register for other training seminars by Netcom Learning on FindaSeminar.com Other seminars from Netcom Learning

By:

Netcom Learning   

For:

This course is intended for Database Administrators, Designer/Developers, System Analyst, Application Developers, and anyone who is interested in working in the database administration field.

Cost:   

see Registration info for seminar cost, group discount etc.

Seminar Summary:

This course will provide students with the concepts needed to properly tune their Oracle9iŽ database for optimal performance. (see full course description)

 

 Seminar / Training class dates & locations

 

No seminar dates for this event are currently scheduled.  Please use the seminars search box above or choose one of the following additional training search options to find similar training.

oracle+9i+database+dba+performance training seminars workshops conferences online training

Providers course catalog

Find seminars by state

Find seminars by city

Request on site training

Use Advanced Search

NEW  Don't miss training you want to attend

Receive a personal Training Alert when training you want to attend comes to your area. Create a personal Training Alert now  it's Free and only takes a minute!


 

 

 

share this page 

print the agenda print agenda for the Oracle9i Database: Performance Tuning seminar

 

 

Training Course Syllabus:


Description
This course provides students with the concepts needed to properly tune their Oracle9iŽ database for optimal performance. You will learn about the tools used to monitor, analyze, measure, and tune your database. This course also helps you prepare for Oracle's exam, Oracle9i Database: Performance Tuning (1Z0-033).

Audience
·  Designers/Developers
·  System Analyst
·  Database Administrators
·  Application Developers
·  Anyone who is interested in working in the database administration field.

Objectives
·  Understand tools and methodologies for tuning your database.
·  Monitor and tune the database buffer cache.
·  Monitor and tune the library cache, dictionary cache, large pool, and other memory structures.
·  Manage Java memory and tune Oracle processes for performance.
·  Understand the physical structure of a database and tune disk I/O.
·  Identify and correct issues with locks and latches.
·  Tune applications by using the correct table and index types.
·  Analyze and improve the performance of SQL statements.
·  Measure sort performance and manage sort-related parameters.
·  Use Oracle Resource Manager to allocate operating system resources and tune the shared server.

Required Prerequisites
 ·  Oracle9i Database: Fundamentals I
 ·  Oracle9i Database: Fundamentals II

Exams
 ·  1Z0-033 : Oracle9i Database: Performance Tuning

Outline
    1. Introduction to Performance Tuning
      1. Performance, Scalability, and Reliability
      2. Software Development Lifecycle
      3. Oracle Tuning Tools
      4. Tuning Methodology
    2. Oracle Memory Tuning I
      1. Oracle Memory Architecture
      2. Database Buffer Cache
      3. Monitor the Hit Ratio
      4. Buffer Cache Advisory Statistics
      5. Other Buffer Tuning Issues
    3. Oracle Memory II
      1. Shared Pool Structure
      2. Oracle Library Cache and Dictionary Cache
      3. The Large Pool
      4. Process and Session Memory
    4. Other Instance Values
      1. Manage Java Memory
      2. Database Writer Processes
      3. The Redo Log Buffer
      4. Database Checkpoints
    5. Database I/O
      1. Manage the Physical Layout of Oracle
      2. Redo Log Files
      3. Temporary Tablespaces
      4. Undo Management
    6. Locks and Latches
      1. Locks
      2. Lock Contention
      3. Oracle Latches
    7. Application Tuning
      1. Review of Terminology and Concepts
      2. Table Types
      3. Index Types
      4. Partitioned Objects
    8. Tuning SQL Statements
      1. Overview of SQL Execution
      2. Database Object Statistics
      3. Hints and Plan Stability
      4. Resource-intensive SQL
      5. Histograms
    9. Sorts
      1. Sorts
      2. Sort Parameters for Dedicated Servers
      3. Sort Parameters for Shared Servers
    10. Other Tuning Topics
      1. Use Performance Manager to Monitor an Operating System
      2. Database Resource Manager
      3. Shared Server Tuning

    Seminar Summary:

    This course will provide students with the concepts needed to properly tune their Oracle9iŽ database for optimal performance. (see full course description)

    print this agenda print agenda for the Oracle9i Database: Performance Tuning training seminar

     view dates and locations for this seminar

     

     

     

    Custom Search