Mastering Oracle Trace Data is a 1-day course based on Cary Millsap’s The Method R Guide to Mastering Oracle Trace Data, 2nd edition. It is the best way for Oracle application developers and DBAs to master Oracle trace data. Each student receives a full Method R Workbench software license for use in code reviews, performance tests, concept proofs, hardware and software evaluations, upgrades, troubleshooting, and more. The course can be delivered online or, in special circumstances, in person. Many customers opt for a few additional classroom hours (at an extra fee) to ensure that all the students are able to install the software and are comfortable using it in their working environment.
This course is the most valuable performance-related course I’ve ever had. The wealth of data in the trace files is hugely valuable and daunting at the same time. With the Method R set of tools, the trace files make sense now. They make it possible, sometimes just within minutes, to get to the very root cause of a performance problem, pretty much eliminating all the trial-error-guess work.
Oracle Professional in Atlanta, Georgia
About Oracle Trace Data
Oracle trace files explain in detail where your programs spend your time. With the right understanding and tools, they help you answer questions that you won’t answer any other way:
- How long does your program take?
- Why does it run for so long? How much time should it take? Is it efficient? Does it waste resources? Is there a problem in your database? Someplace else?
- What performance changes will your users notice if you change something about your system?
- How can you know when your optimization work is done?
Whether you’ve bought your software or built it yourself, trace files help you make better informed decisions about performance. They help developers optimize software as they build it, they help DBAs fix unexpected performance problems after you’ve gone live, and they help you avoid surprises during upgrades.
- Fundamentals of computer system performance
- Using Oracle trace data to diagnose and solve problems
- Using trace data to predict performance changes
- Collecting trace data in different architectures
- Understanding trace files and what they measure
- Oracle timed events and their meanings
- Using Method R Workbench software
What You Get
- Admission to the course
- A PDF copy of The Method R Guide to Mastering Oracle Trace Data, 2nd edition (bound copies are available separately at Amazon.com)
- A one-person, one-year license for the Method R Workbench software package
In class, you will learn how to use the Method R Workbench software package, which is included with each enrollment. This package includes all of the following software tools:
- A user experience duration profiler that shows exactly how your programs spend your time, using color and structure to guide your analysis.
- A flexible and versatile utility suite that includes a trace file data mining tool, utilities for adjusting trace files, and more.
- Method R Trace, our zero-click trace file collector for users of the Oracle SQL Developer interactive development environment.
When taught online, the course consists of two 3-hour modules delivered on consecutive days. When taught in person, the course runs for one day from 9 a.m. to 4 p.m.
Optional Follow-Up Labs
Our most successful students are the ones who use the tools and techniques from the course to solve real problems immediately after completing the course. Not all students take the time or have the commitment to do this.
You can ensure that your students put their classroom experience to work right away by booking optional lab time. The labs, which we can schedule for half a day or more, gives students extra time with the instructor to install the Method R software and accelerate their learning curve with supervised practice.
The Method R Guide to Mastering Oracle Trace Data, 2nd edition by Cary Millsap is a comprehensively detailed, full-color, 235-page textbook that serves as a valuable reference long after you complete the course.
Many courses are taught by Cary Millsap. Cary has been an Oracle performance specialist since 1990. He is an Oracle ACE Director, an Oak Table Network founder, and former Vice President at Oracle Corporation. He is the author of Optimizing Oracle Performance (O’Reilly 2003), for which he and coauthor Jeff Holt were named Oracle Magazine’s 2004 Authors of the Year, and The Method R Guide to Mastering Oracle Trace Data, 2nd edition. He is responsible for designing and developing much of the software that you’ll see in class.
See https://method-r.com/pricing for current pricing. Pricing for optional follow-up lab time varies by headcount, location, and duration. Taxes and additional service fees may apply.
Groups of 10 or more registering simultaneously qualify for a course fee discount. Some user groups offer discounts for their members. Existing Method R software licensees with active software maintenance contracts receive a course fee discount instead of redundant software licenses.
Hosting a Public Course at Your Facility
Looking for first-class education without the travel costs for your whole team? By hosting the course at your facility and helping us attract students, we can bring the course right to you. Hosting a public course saves money and provides the ultimate in convenience for you and your colleagues. Write us at firstname.lastname@example.org if you’re interested in hosting a public course.
Hosting a Private Course
A private course taught at your facility ensures that your staff can be completely open with their classroom discussions. The course curriculum fits tightly into the scheduled format, but we can offer additional days of instruction in which your staff can work directly with the instructor on the subject matter in your company’s specific context.
Our minimum student count for private courses varies by location and is generally proportional to the time and expense required to reach your facility from our office near the DFW Airport. Write us at email@example.com if you’re interested in hosting a private course.
The course requires a quiet room with good lighting, comfortable classroom-style seating, and desktop space for each student. AC power for each student is nice, but not necessary. The instructor will need:
- a digital projector with resolution ≥ 1024×768 and USB-C (Thunderbolt 3), HDMI, or VGA input
- a screen for the projector
- access to 120V or 240V AC power
- desktop space
- a chair
- an Internet connection (RJ-45 or Wi-Fi) is helpful
- a whiteboard or flip chart is helpful
- Posted by methodradmin
- On 2008-04-30
- 0 Comments