Training Course:Oracle Performance Management Using Response Time ProfilingSchool/Trainer:OGI School of Science & Engineering, Center for Professional Development
Beaverton, Oregon, United States
Course Format: Classroom | E-learning | Virtual Class | Online | On-site | Blended | Self-paced
Course Description:
'' This course is intended to teach students a scientific method for diagnosing Oracle system performance problems rapidly and accurately, no matter what their root cause. Students learn the importance of a business-task focused approach to Oracle performance problem diagnosis and repair. A repeatable and reliable method for diagnosing performance problems, Method R, is reviewed and used to help students learn how to quickly find and fix Oracle performance problems.
Collecting and using Oracle trace data is covered extensively and students learn how to understand and interpret trace data file contents. Emphasis is placed on collecting properly scope trace data and the use of application instrumentation to make the job easier. Students learn how to create response time profiles for the collected trace data that allows them to pinpoint the root cause of any performance problem quickly and accurately.
The student’s attention is focused on how the Oracle database works in order to know how to interpret the response time profiles generated from the collected trace data properly. Case studies are used to give students an opportunity to walk through actual problem scenarios on their own to get real world examples of implementing their knowledge.
This course presents strategies that can be carried forward directly to common problems and customized for solving less common ones. The result is a fortified foundation for diagnosing and repairing Oracle performance problems in their own ever-changing environments.
The course is conducted in English.
The course is organized into the following segments:
Why Collect Oracle Trace Data? An Introduction to Method R
Problems with Conventional Tuning Methods (Method C)
Method R
Target identification
What is 10046 Trace Data
Overview of Oracle Tracing Mechanisms
Ways to Manipulate Traces
Reading a 10046 Trace File
How to Collect Trace Data with Proper Instrumentation
What is properly instrumented trace data?
Instrumentation with Client Identifier
Instrumentation with DBMS_APPLICATION_INFO
Instrumentation with HOTSOS_ILO
Special Considerations
How to Profile Trace Data
Manually Profiling Trace Data
Using Hotsos P5 Profiler to Profile Trace Data
Responding to Profiled Trace Data
Review common problem events exposed in response time profiles
Analyze profile output and learn to make recommendations for corrective actions.
Conclusion
Review
Perspective
Course wrap-up
Using the free Profiler trial
...''
Please go to the school's official website for training price and schedule:
http://www.cpd.ogi.edu/
Phone:503-748-1219
School Address:
20000 NW Walker Rd
Beaverton, OR 97006
USA
Jobs & Resumes: Beaverton
Houses & Roommates: Beaverton
Search other schools for Oracle Performance Management Using Response Time Profiling training resources.
Other training courses offered by OGI School of Science & Engineering, Center for Professional Development:
Optimizing Oracle SQL, Intensive
Programming with Microsoft .NET Framework (C# .NET)
Practical Windows Presentation Foundation (WPF)
Notice: The course description on this page was captured from the Internet as historical reference or submitted by visitors. It was archived statically and not updated from day to day.
Tips:
Schools can use this unlimited free web marketing service by submitting their course descriptions and school introductions. Two outbound links will be granted to each posting. |
|
| 
