|
Provided by: 123-CBT Computer Based Training Oracle9i Performance Tuning Architecture Strategy |
 |
Training
Provided by 123-CBT Computer Based Training
In this course, you are introduced to the strategies and techniques used for tuning the Oracle9i server.
o Identify common tuning problems that directly affect database performance.
o Identify appropriate tuning goals.
o Identify key information recorded by the alert log.
o Identify the parameters that control the location and format of the alert log file.
o Identify the different methods available for generating user process trace files.
o Identify the functions of the DBA views used to provide data storage statistics.
o Match the dynamic performance views with the statistics they provide.
o Match the V$ views used to collect system-wide statistics with their functions.
o Identify the factors taken into consideration in selecting the physical structure for data.
o Match the index types with their benefits.
o Identify the key usage of index organized tables.
o Identify the features of the Database Resource Manager.
o Identify the guidelines used to administer resource consumer groups.
o Identify the processes implemented by resource plans and resource plan directives.
o Identify the measures that can be taken to tune memory performance.
o Identify the I/O tuning areas that can improve overall system performance.
o Identify the CPU tuning practices that can improve overall system performance.
o Match the tuning goals with the appropriate job role.
o Identify common tuning problems that directly affect database performance.
o Identify appropriate tuning goals.
o Sequence the steps associated with tuning an Oracle9i database.
Unit 2: Alert Log, Trace Files, and Events 1 - 2 hours
o Identify key information recorded by the alert log.
o Identify the parameters that control the location and format of the alert log file.
o Identify the different methods available for generating user process trace files.
o Identify the parameters that control the location and format of user process trace files.
o Identify the V$ views used to obtain wait event information.
o Identify key statistics
Learn To:
o Match the tuning goals with the appropriate job role.o Identify common tuning problems that directly affect database performance.
o Identify appropriate tuning goals.
o Identify key information recorded by the alert log.
o Identify the parameters that control the location and format of the alert log file.
o Identify the different methods available for generating user process trace files.
o Identify the functions of the DBA views used to provide data storage statistics.
o Match the dynamic performance views with the statistics they provide.
o Match the V$ views used to collect system-wide statistics with their functions.
o Identify the factors taken into consideration in selecting the physical structure for data.
o Match the index types with their benefits.
o Identify the key usage of index organized tables.
o Identify the features of the Database Resource Manager.
o Identify the guidelines used to administer resource consumer groups.
o Identify the processes implemented by resource plans and resource plan directives.
o Identify the measures that can be taken to tune memory performance.
o Identify the I/O tuning areas that can improve overall system performance.
o Identify the CPU tuning practices that can improve overall system performance.
Audience
This intended audience for this course are Database Administrators.Deployment Options
Internet / Intranet, Download, LAN, WorkstationAccreditation
NASBA credits: 4 CPE CreditsLanguage Options
American English, Brazilian Portuguese, SpanishTotal Learning Time
6 to 8 hours64331 Objectives
Unit 1: Tuning the Oracle9i Server: Overview 1 - 2 hourso Match the tuning goals with the appropriate job role.
o Identify common tuning problems that directly affect database performance.
o Identify appropriate tuning goals.
o Sequence the steps associated with tuning an Oracle9i database.
Unit 2: Alert Log, Trace Files, and Events 1 - 2 hours
o Identify key information recorded by the alert log.
o Identify the parameters that control the location and format of the alert log file.
o Identify the different methods available for generating user process trace files.
o Identify the parameters that control the location and format of user process trace files.
o Identify the V$ views used to obtain wait event information.
o Identify key statistics
|
|
||||||||||
Oracle9i Performance Tuning Architecture Strategy
--
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
-...
