ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
ExitCertified Formation Formation de Java Solaris Red Hat IBM Symantec Siebel PeopleSoft
 
start courses and schedules education savings it certification education solutions
recherche de formation
Faites confiance à votre formation en TI   |
Oracle University reconnaît ExitCertified comme Partenaire en formation de l’année en Amérique du Nord.

Oracle Database 10g: Performance Tuning Self-Study Course

Format: Formation individualisée sur DVD/CD
Autres formats:
 
 

Get the most out of your 10g Database by learning performance tuning methods that maximize the utility of the database. This course introduces the various tuning methodologies and tunable componenets of an Oracle database.

Students learn how to benefit from Oracle Database 10g automatic tuning features, as well as manual tuning methods using the Statspack tool. Through-out the course, students experience the tuning of an Oracle Database through a series of simulated demonstrations.

Learn To:
  • Recognize the various Oracle Database tuning methodologies
  • Use Statspack reports
  • Monitor the database and utilize database advisors
  • Diagnose and tune common performance problems
  • Use Automatic Workload Repository to tune the database
 
 

Compétences acquises
 

  • Diagnose and tune common database performance problems

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

  • Use Statspack reports to tune the database

 

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

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

  • Utilize database advisors to proactively tune an Oracle database

Qui peut en profiter
 

  • Database Administrators

  • Support Engineer

 

  • Technical Consultant

Préalables
 

  • Knowledge of database administration

 
     
    Buy This Training
    Enroll For This Class
    Oracle DB PeopleSoft Hyperion Ce cours autoformation est certifié par le .

    Oracle University a nommé ExitCertified Partenaire de l’année 2011

    Il y a une différence....découvrez-la.
    Buy Training Now Ask A Question About This Training
    Code: D49111
    Format: Formation individualisée sur DVD/CD
    Durée:
    Certifié par: Oracle
    Frais d’inscription (CAD): 1,103$
    Oracle University Awards ExitCertified the North American Partner of the Year Award for 2011
    Recherchez des cours semblables
    Cours connexes

     

    Oracle Database 10g: Performance Tuning Self-Study Course Contenu détaillé
     
     
    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
    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 is your Authorized IT Training Partner  
      Lorsque vous suivez un cours certifié chez ExitCertified, vous apprenez directement des concepteurs des produits que vous utilisez. Notre engagement envers la communauté des TI, de même que notre autorisation à offrir des cours certifiés, vous assurent une expérience de formation supérieure. Il y a une différence. Apprenez directement de la source.

    Il y a une différence. Apprenez directement de la source.    		  
    Training Contacts  
       
    Canada United States

    Formation à Montréal :: 514.876.1666
    Formation à Ville de Québec :: 514.876.1666
    Formation à Ottawa :: 613.232.3948
    Formation à Toronto :: 416.487.3948

    Formation à Vancouver :: 604.633.3948
    Formation à Victoria :: 1.866.328.3948
    Formation à Calgary :: 403.291.2855
    Formation à Edmonton :: 780.441.3948
    Formation à Regina :: 1.866.328.3948

    		 Formation à Sacramento :: 916.669.3970
    Formation à San Francisco :: 415.975.3948
    Formation à San Jose :: 408.288.3948
    Formation à Las Vegas :: 1.800.803.3948
    Formation à Phoenix :: 602.889.9350
    À travers le monde - 613.232.3948 Des questions?
    Il nous fait plaisir de vous aider. Transmettez-nous ce formulaire par courriel et nous vous répondrons dans les plus brefs délais.
       



    (c) 2012 ExitCertified Corp. Tous droits réservés.


    ExitCertified est un fournisseur international agréé de formation en technologies. Voici quelques-uns de nos cours les plus souvent consultés :
     
    Formation Sun Formation Oracle Formation Symantec Formation IBM Formation Red Hat :: Linux
    Formation Java, Cours J2EE, Formation JSP, servlets, EJB, Struts, réseaux, Formation Solaris, Java Composite Application Platform (JCAPS), SeeBeyond, XML, Formation Solaris 10, certification Java, certification Solaris Cours PeopleSoft, 11g, Formation Oracle SQL, Oracle PL/SQL, DBA, Hyperion, Fusion Middleware, 10g, 9i, certification 11g, certification DBA, certification Oracle Formation NetBackup, Cours Veritas, protection contre les virus, sécurité des TI, certification Symantec DB2, OS/400, Formation zSeries, s/390, iSeries, AIX SUSE, Formation RedHat
             
    Formation MySQL Formation Apple Formation en gestion de projet    
    Base de données MySQL Cours Apple, Formation Leopard Formation du PMI