ExitCertified Training Training with Java Solaris Red Hat IBM Symantec Siebel PeopleSoft Certified
 
Start
Training Courses and Schedules
Training Savings
IT Certification
Training Solutions
Loading
Trust Your IT Training   |
Oracle University Awards ExitCertified Corporation with North American Partner of the Year.
Email Training Course

Oracle Database 10g: Performance Tuning

Format: Instructor-Led Classroom
Other Formats:
 
 

Get the most out of your 10g Database by learning performance tuning methods that maximize the utility of the database. Students learn how to benefit from Oracle Database 10g automatic tuning features, as well as practicing the manual tuning methods using the statspack tool. After clearly defining the various methodologies one can use to tune an Oracle Database, the course covers the various tunable components of an Oracle Database. Throughout the course, students experience hands-on the tuning of an Oracle Database by practicing through a series of workshops.

This course counts towards the Hands-on course requirement for the Oracle Database 10g Administrator Certification. Only instructor-led inclass or instructor-led online formats of this course will meet the Certification Hands-on Requirement. Self Study CD-Rom and Knowledge Center courses are excellent study and reference tools but DO NOT meet the Hands-on Requirement for certi
 
Oracle Certified Training Course   Oracle Training Savings
 

Skills Gained
 

  • Use the Oracle Database tuning methodology appropriate to the available tool

  • Utilize database advisors to proactively tune an Oracle database

  • Use the tools based on the Automatic Workload Repository to tune the database

 

  • Use Statspack reports to tune the database

  • Diagnose and tune common database performance problems

  • Use Enterprise Manager performance-related pages to monitor an Oracle database

Who Can Benefit
 

  • Database Administrators

  • Support Engineer

 

  • Technical Consultant

Prerequisites
 

  • Knowledge of Database Administration

 

    Suggested Next Courses
     

    • Oracle Enterprise Manager 10g Grid Control

    • Oracle Database 10g: SQL Tuning Workshop

    		 

    • Oracle Database 10g: Real Application Clusters
     
    Enroll For This Class
    Enroll For This Class
    Oracle DB PeopleSoft Hyperion This course is taught by Certified Oracle instructors.

    Oracle University has awarded ExitCertified the 2009 Partner of the Year and Outstanding Instructor Quality Awards

    There is a difference....learn more.
    Training Class Enrollment Ask A Question About This Training
    Code: 10G-PERF-TUNE
    Format: Instructor-Led Classroom
    Length: 4
    Certified By: Oracle
    Tuition (USD): $2,400
    Browse Similar Training Classes
    Related training classes
    Sort Schedule By: 
         
    Virtual Live Class  Sep.7 - Sep.10.2010 course register
    Virtual Live Class  Oct.18 - Oct.21.2010 course register
    Virtual Live Class  Dec.7 - Dec.10.2010 course register
    Virtual Live Class  Jan.18 - Jan.21.2011 course register
    Belmont, CAMap Oct.25 - Oct.28.2010 course register
    Denver, COMap Oct.5 - Oct.8.2010 course register
    Orlando, FLMap Nov.16 - Nov.19.2010 course register
    Chicago, ILMap Sep.28 - Oct.1.2010 course register
    New York, NYMap Nov.9 - Nov.12.2010 course register
    Houston, TXMap Sep.21 - Sep.24.2010 course register
    Reston, VAMap Nov.30 - Dec.3.2010 course register
    Bellevue, WAMap Nov.30 - Dec.3.2010 course register
           
       
    Request Other Course Date Request Course On-Site
     

    Oracle Database 10g: Performance Tuning Content Details
     
     
    Performance Tuning Overview
    • Write appropriate tuning goals
    • Apply the tuning methodology
    • Balance performance and safety trade-offs
    • Identify common tuning problems
    • Log a performance Service Request with Oracle Support
    Statistics and Wait Events
    • Identify dynamic performance views useful in tuning
    • Identify key tuning components of the alert log file
    • Identify key tuning components of user trace files
    • Use dynamic performance views to view statistics and wait events
    Metrics, Alerts, and Baselines
    • View metrics using the metrics history views
    • Create metric thresholds
    • View alerts
    • Create metric baselines
    • Enable adaptive thresholds
    Using Statspack
    • Install Statspack
    • Create Statspack snapshots
    • Generate Statspack reports
    • Identify the major sections of the Statspack report
    Using AWR
    • Create and manage AWR snapshots
    • Generate AWR reports
    • Create snapshot sets and compare periods
    • Generate ADDM reports
    • Generate ASH reports
    Reactive Tuning
    • Use Enterprise Manager pages to identify symptoms
    • Eliminate operating system issues
    Tuning the Shared Pool
    • Diagnose shared pool problems
    • Size the shared pool
    • Size the reserved area
    • Keep objects in the shared pool
    		 
    Tuning the Buffer Cache
    • Describe the buffer cache architecture
    • Size the buffer cache
    • Resolve common performance issues related to the buffer cache
    • Use common diagnostic indicators to suggest a possible solution
    Automatic Shared Memory
    • Enable Automatic Shared Memory
    • Set auto-tuned memory parameters
    • Set the manually tuned SGA parameters
    • Use the SGA advisor to set SGA target
    Checkpoint and Redo Tuning
    • Diagnose checkpoint and redo issues
    • Implement Fast Start MTTR target
    • Monitor performance impact of Fast Start MTTR target
    • Implement multiple database writers
    • Tune the redo chain
    • Size the redo log file
    • Size the redo log buffer
    Tuning I/O
    • Diagnose database I/O issues
    • Describe the Stripe and Mirror Everything (SAME) concept
    • Explain the benefits of asynchronous I/O
    • Choose appropriate I/O solutions
    Tuning PGA and Temporary Space
    • Diagnose PGA memory issues
    • Size the PGA memory
    • Diagnose temporary space issues
    • Specify temporary tablespace parameters for efficient operation
    Tuning Block Space Usage
    • Tune segment space management
    • Convert from dictionary managed tablespaces
    • Convert to automatic segment space management
    • Tune block space management
    • Diagnose and correct row chaining
    • Diagnose table fragmentation
    • Compare characteristics of bigfile and smallfile tablespaces
    Initial Configuration
    • List best practices identified throughout the course


      ExitCertified Training with Java Solaris Red Hat IBM Symantec Apple MySQL Siebel PeopleSoft  
      When you take a certified course with ExitCertified, you are learning from the creators of the products you use. Our commitment to your IT community, along with our authorization to deliver certified courses, ensures you receive a premium training experience.

    There is a difference. Learn from the source.    		  
         
    Training Contacts    
    Training Provided Across North America
         
    Atlanta Training
    Austin Training
    Boston Training
    Chicago Training
    Dallas Training     		Denver Training
    Hampton Training
    Houston Training
    Indianapolis Training
    Kansas City Training     		Los Angeles Training
    Las Vegas Training
    New York Training
    Philadelphia Training
    Phoenix Training     		Sacramento Training
    San Francisco Training
    San Jose Training
    Tampa Training
    Washington Training

    View All US Training Centers
    Worldwide and All US Cities:
    408.288.3948    		 Got Questions?
    We are happy to help. Just email us with this form and we'll get back to you shortly.
       



    (c) 2010 ExitCertified Corp. All rights reserved.


    ExitCertified is a global provider of authorized technology training. Some of our popular course topic include:
     
    Sun Microsystems Training Oracle Training Symantec Training IBM Training Red Hat - Linux Training
    Java Training, J2EE Training, JSP Training, Java Courses, Servlets Training, EJB Training, Struts Training, Networking Courses, Solaris Training, Java Composite Application Platform (JCAPS) Training, Java Certification, SeeBeyond Training, XML Training, Solaris Certification, Corporate Training PeopleSoft Training, 11g Training, 11g Certification, Oracle SQL, Oracle PL/SQL, DBA Training, Oracle Certification, Hyperion Training, Fusion Middleware Training, 10g Training, Siebel Training, JD Edwards Training, Stellent Class, BEA Courses, e-Business Suite Altiris Training, NetBackup Training, Veritas Training, Symantec Certification, Virus Protection Courses, IT Security Training DB2 Training, Cognos Classes, WebSphere Training, CICS Training, Informix, Rational Training, Lotus, Notes and Domino Training, Tivoli Courses, AIX Class, CISCO Training, VMWare Training SUSE Training, RedHat Training , JBoss Training
             
    MySQL Training Apple Training Hitachi - HDS Training Project Management PMI Training  
      Apple Course, Leopard Training, Xsan Training