|
Provided by: 123-CBT Computer Based Training Oracle9i Peformance Tuning Managing Memory and Disk I O |
 |
Training
Provided by 123-CBT Computer Based Training
This course introduces students to the importance of good initial database design, and the methods used to tune an Oracle9i production database. Students learn how to use the available Oracle tools to recognize, troubleshoot, and resolve common performance-related problems in administering an Oracle database.
o Match the OPTIMIZER_MODE parameter values with their description.
o Identify the methods of creating stored outlines.
o Identify the three major areas of the Shared Pool.
o Identify the parameters used to tune the Shared Pool.
o Identify the goals for tuning the Library Cache.
o Identify the descriptions of redo entries.
o Match the statistics used to diagnose disk I/O contention with their descriptions.
o Identify the two parameters that allow the DBA to limit the amount of memory used for each Java session.
o Identify the performance guidelines to reduce the activity on an overloaded disk.
o Identify the methods of striping.
o Identify the initialization parameter that indicates the size of read calls during full table scans.
o Match the optimizer modes with their descriptions.
o Match the OPTIMIZER_MODE parameter values with their description.
o Identify the methods of creating stored outlines.
o Set the value of the USE_STORED_OUTLINES parameter.
o Match the values of the USE_PRIVATE_OUTLINES parameter with their descriptions.
o Identify the procedures in the DBMS_OUTLN package used to manage stored outlines.
o Identify the diagnostic tools available for evaluating the performance of SQL statements and PL/SQL modules.
o Identify the sections of the STATSPACK SQL report.
o Designate the execution plan Oracle follows for executing a SQL statement by creating an EXPLAIN PLAN.
o Sequence the steps to diagnose SQL statement performance with SQL TRACE and TKPROF.
o Identify the advantages of using SQL*PLUS AUTOTRACE instead of SQL TRACE.
o Identify the two methods of collecting statistics.
o Identify the data dictionary views populated by gathering table, index, and column statistics.
o Sequence the steps in copying
Learn To:
o Match the optimizer modes with their descriptions.o Match the OPTIMIZER_MODE parameter values with their description.
o Identify the methods of creating stored outlines.
o Identify the three major areas of the Shared Pool.
o Identify the parameters used to tune the Shared Pool.
o Identify the goals for tuning the Library Cache.
o Identify the descriptions of redo entries.
o Match the statistics used to diagnose disk I/O contention with their descriptions.
o Identify the two parameters that allow the DBA to limit the amount of memory used for each Java session.
o Identify the performance guidelines to reduce the activity on an overloaded disk.
o Identify the methods of striping.
o Identify the initialization parameter that indicates the size of read calls during full table scans.
Audience
The intended audience for this course includes Database Administrators, Technical Support Professionals, and System Administrators.Deployment Options
Internet / Intranet, Download, LAN, WorkstationAccreditation
NASBA credits: 4 CPE CreditsLanguage Options
American English, Portuguese, SpanishTotal Learning Time
6 to 8 hours64332 Objectives
Unit 1: SQL Statement Tuning 1 - 2 hourso Match the optimizer modes with their descriptions.
o Match the OPTIMIZER_MODE parameter values with their description.
o Identify the methods of creating stored outlines.
o Set the value of the USE_STORED_OUTLINES parameter.
o Match the values of the USE_PRIVATE_OUTLINES parameter with their descriptions.
o Identify the procedures in the DBMS_OUTLN package used to manage stored outlines.
o Identify the diagnostic tools available for evaluating the performance of SQL statements and PL/SQL modules.
o Identify the sections of the STATSPACK SQL report.
o Designate the execution plan Oracle follows for executing a SQL statement by creating an EXPLAIN PLAN.
o Sequence the steps to diagnose SQL statement performance with SQL TRACE and TKPROF.
o Identify the advantages of using SQL*PLUS AUTOTRACE instead of SQL TRACE.
o Identify the two methods of collecting statistics.
o Identify the data dictionary views populated by gathering table, index, and column statistics.
o Sequence the steps in copying
|
|
||||||||||
Oracle9i Peformance Tuning Managing Memory and Disk I O
--
About The Training Provider: 123-CBT Computer Based Training
123-CBT Computer Based Training - 123-CBT offers discount pricing on top quality eLearning
programs from leading computer based training providers. Many of the training courses are available both online or on CD so that you can study at home at your own pace:
E-Learning available for
- ABAP 6. 10
- Access 2003
- Acrobat 6. 0
- ASP
- ASP. NET
- C
- Captivate 1. 0
- Crystal Reports 8. 5
- Crystal Reports v10
-...
