Method R 90-Day Free Trial Program

Please complete a session’s prerequisites before its scheduled start time. All times listed are USA Central Time.

Session 1 – 2020-05-20 10:00a Central Time

In this session, Cary Millsap will introduce you to the program and present about the motives and origins for the optimization method we call Method R and the software we’ve built to implement it.

  1. Registration. Join our Method R 90-day free trial program, sponsored by Cintra Software & Services.
  2. Recording. Each online session will be recorded. Students will be given access to the recordings.
  3. Communication. We will communicate during the program using Slack. Shortly after you register, you will receive an invitation to install Slack and set up your profile. Our workspace name is Method R and our URL is https://method-r.slack.com. Use the #technical channel for questions about content, the #general channel for questions about the program, and #random for everything else. If you’re not already an experienced Slack user, you might find Slack’s quick tutorials useful. Click here to view those tutorials.
  4. File sharing. At various times throughout the program, we will invite students to share files with the instructor team. We intend to discuss as many of these files as we can during the online sessions and on Slack. Do not share a file with us if you don’t want other students to see it.
  5. Method R Workbench. Download and install the Method R Workbench application on your laptop or desktop computer. This will prepare you to use the product when you receive your license key. Click here to visit the downloads page.
  6. Method R Trace (optional). If you do not use Oracle SQL Developer, you may skip this step. Install the Method R Trace extension for Oracle SQL Developer. This will prepare you to use the product when you receive your license key. Click here to view the installation instructions.
  7. License key. The Cintra sales team will provide a software license key that will activate both the Method R Workbench application and the Method R Trace extension for Oracle SQL Developer through 2020-08-18. Use this license key only if you accept the Method R Software License Agreement. Do not use the license key if you don’t accept this Agreement.
  8. Reading. Study the items listed on our “Getting to Know Method R” page. It’s 15 minutes of videos and easy reading. Click here to view the page.
  9. Consent. Copy the following statements into an email and send to courses@method-r.com and jdocherty@cintra.com:
1. Recording. I understand that the weekly online sessions will be recorded. By participating in these sessions, I consent to allow Method R Corporation and Cintra Software & Services to make, keep, replay, and distribute the recording.

2. Communication. By posting messages to Slack channels in the workspace called “Method R”, I consent to allow other students in this course and future courses to see conversations in which I am a participant.

3. File Sharing. By uploading trace files, I consent to allow Method R Corporation and Cintra Software & Services to keep those trace files and use them as demonstrations in this and other public events.

4. Software License. I accept the Method R Software License Agreement published at https://method-r.com/method-r-software-license-agreement/.

Session 2 – 2020-05-27 10:00a Central Time

In this session, Cary Millsap will show you how to conduct the software installation verification steps and guide you through the first part of the “Thinking Clearly about Performance” material in MOTD chapter 1.

  1. Software. Install your license key by using the Method R Workbench Help › License feature. After you install the license key for the Workbench application, the Method R Trace extension for Oracle SQL Developer will automatically find the key. Do not use the license key if you do not accept the Method R Software License Agreement. Click here to view the Agreement.
  2. Workbench verification. Open the Method R Workbench application. Use the load sample files feature and skim through the resulting HTML page to verify that the software is installed and ready to go. Explore the buttons and preferences and the menus.
  3. Trace verification (optional). Open Oracle SQL Developer and connect to Oracle with Method R Trace installed. Use View › Trace File Downloads to see the Trace File Downloads panel. Follow the instructions on the Method R Trace product page to verify that the software is installed and ready to go. Load a file from SQL Developer into the Workbench by dragging and dropping. Explore the product and its preferences.
  4. Reading. Read the Cary Millsap blog post called, What happened to “when the application is fast enough to meet users’s requirements?”
  5. Reading. Read chapter 1 of The Method R Guide to Mastering Oracle Trace Data, 3rd edition. You can access the PDF from within the Method R Workbench application, using the Help › Mastering Oracle Trace Data menu option.

Session 3 – 2020-06-03 10:00a Central Time

In this session, Cary Millsap will complete the online discussion of chapter 1 and then demonstrate the Method R Workbench application with trace files submitted by students and others.

  1. Discussion. Ask your questions about session 2 on Slack.
  2. Reading. Read MOTD chapter 2. This will give you a complete walk-through of solving a problem using Oracle extended SQL trace data.
  3. Reading. Read MOTD chapters 3 and 4. This will prepare you for creating some trace files that we can discuss during the program.
  4. Tracing. Trace the execution of some task. Ideas: trace a simple select from dual, just to make sure you know how; trace a statement from your application that you’re curious about; trace a proper experience (an execution of a business function, such as a click, a report, or a batch job) on a test system.
  5. File sharing (optional). If you generate some interesting trace data, upload it for us to have a look and discuss during the program. Upload .trc files to Slack if you want to share them with your classmates, or to Dropbox at https://www.dropbox.com/request/8efEY7GR2HU4vTxFkqZG if you want only your instructors to have a copy. Make sure you explain the experience your file represents.

Session 4 – 2020-06-10 10:00a Central Time

In this session, Cary Millsap will review chapters 2, 3, and 4.

  1. Discussion. Ask your questions about our prior sessions on Slack.
  2. File sharing. Generate and share some interesting trace files. Upload .trc files to Slack if you want to share them with your classmates, or to Dropbox at https://www.dropbox.com/request/8efEY7GR2HU4vTxFkqZG if you want only your instructors to have a copy. Make sure you explain the experience your file represents.

Session 5 – 2020-06-17 10:00a Central Time

In this session, Cary Millsap will review chapters 6 and 7 of the book and show some Method R Workbench demonstrations.

  1. Reading. Read MOTD chapters 6 and 7.
  2. Discussion. Ask your questions about our prior sessions on Slack.
  3. File sharing. Generate and share some interesting trace files. Upload .trc files to Slack if you want to share them with your classmates, or to Dropbox at https://www.dropbox.com/request/8efEY7GR2HU4vTxFkqZG if you want only your instructors to have a copy. Make sure you explain the experience your file represents.

Session 6 – 2020-06-24 10:00a Central Time

In this session, Cary Millsap will discuss trace file scoping and connection pooling.

  1. Discussion. Ask your questions about our prior sessions on Slack.
  2. File sharing. Generate and share some interesting trace files. Upload .trc files to Slack if you want to share them with your classmates, or to Dropbox at https://www.dropbox.com/request/8efEY7GR2HU4vTxFkqZG if you want only your instructors to have a copy. Make sure you explain the experience your file represents.

Session 7 – 2020-07-01 10:00a Central Time

In this session, Cary Millsap will demonstrate the new Method R Workbench 9. This is a major release with several important new features.

  1. Reading. Read MOTD chapter 8 and the mrskew manual page, available through the Help › mrskew menu option.
  2. Discussion. Ask your questions about our prior sessions on Slack.
  3. File sharing. Generate and share some interesting trace files. Upload .trc files to Slack if you want to share them with your classmates, or to Dropbox at https://www.dropbox.com/request/8efEY7GR2HU4vTxFkqZG if you want only your instructors to have a copy. Make sure you explain the experience your file represents.

Session 8 – 2020-07-08 10:00a Central Time

In this session, Cary Millsap will tell the story of a tricky performance problem that had eluded diagnosis for several months. He will demonstrate how you can use Method R Workbench to solve similar problems.

  1. Discussion. Ask your questions about our prior sessions on Slack.
  2. File sharing. Generate and share some interesting trace files. Upload .trc files to Slack if you want to share them with your classmates, or to Dropbox at https://www.dropbox.com/request/8efEY7GR2HU4vTxFkqZG if you want only your instructors to have a copy. Make sure you explain the experience your file represents.

Session 9 – 2020-07-15 10:00a Central Time

In this session, Cary Millsap will host Mister Skew (mrskew) Day. He will lead you through many examples of useful things you can do with mrskew.

  1. Reading. Refresh your reading of MOTD chapter 8 and the mrskew manual page, available through the Help › mrskew menu option.
  2. Discussion. Ask your questions about our prior sessions on Slack.
  3. File sharing. Generate and share some interesting trace files. Upload .trc files to Slack if you want to share them with your classmates, or to Dropbox at https://www.dropbox.com/request/8efEY7GR2HU4vTxFkqZG if you want only your instructors to have a copy. Make sure you explain the experience your file represents.

Session 10 – 2020-07-22 10:00a Central Time

In this session, Cary Millsap will host Mister Skew (mrskew) Day, part 2. He has some examples left to show you that will finish off our discussion of this extraordinarily versatile tool.

  1. Reading. Refresh your reading of MOTD chapter 8 and the mrskew manual page, available through the Help › mrskew menu option.
  2. Discussion. Think about mrskew queries that you would like to be able to use. Have a look at our prepackaged .rc files (use mrskew --rc=all.rc --listrc to find the directory where they’re stored). Discuss the queries you are interested in in Slack. Let us know where you are having troubles; we will be happy to help.
  3. File sharing. Generate and share some interesting trace files. Upload .trc files to Slack if you want to share them with your classmates, or to Dropbox at https://www.dropbox.com/request/8efEY7GR2HU4vTxFkqZG if you want only your instructors to have a copy. Make sure you explain the experience your file represents.

Session 11 – 2020-07-29 10:00a Central Time

In this session, Cary Millsap will explain “unaccounted-for” time in trace files: how it is calculated, what it looks like in real life, and what it means.

  1. Reading. There is no reading necessary before today’s session. If you want to review the material, the information you’ll need is in MOTD chapter 6 and 19.
  2. File sharing. Generate and share some interesting trace files. Upload .trc files to Slack if you want to share them with your classmates, or to Dropbox at https://www.dropbox.com/request/8efEY7GR2HU4vTxFkqZG if you want only your instructors to have a copy. Make sure you explain the experience your file represents.

Session 12 – 2020-08-05 10:00a Central Time

In this session, Cary Millsap will explain why and how to instrument your application. He will describe an instrumentation strategy that makes it easy both to obtain the right trace files and isolate the individual experiences that you want to study, no matter how complex your application is.

  1. Reading. You will find it helpful if you review MOTD chapters 4 and 12 before the session.
  2. File sharing. Generate and share some interesting trace files. Upload .trc files to Slack if you want to share them with your classmates, or to Dropbox at https://www.dropbox.com/request/8efEY7GR2HU4vTxFkqZG if you want only your instructors to have a copy. Make sure you explain the experience your file represents.

Session 13 – 2020-08-12 10:00a Central Time

In this capstone session of the Method R Workbench 90-Day Trial Program, Cary Millsap will illustrate a whole new, more accurate way of understanding application performance that will make you less susceptible to being disappointed and help you understand a better way to plan, measure, and test the operations that developers and DBAs do every day. He will explain system performance management and capacity planning, using two simple Excel spreadsheets, in a way that you’ll probably never forget.