Categories
Blog Posts Videos

Some things you probably didn’t know about Oracle tracing (Dallas edition)

It really is OK to trace everything—even your whole database if you want to. But you have to do it right. This session explains how to safely trace anything you want, and why you’d want to trace your programs in the first place. This is a Dallas Oracle Users Group (DOUG) webinar presentation, recorded on 7 May 2020.

Some things you probably didn’t know about Oracle tracing
Categories
Oracle Monographs Papers

Preventing the Post-Production Performance Problem

Preventing the Post-Production Performance Problem

How confident are you that those new features you’re adding to your production application will be fast and efficient? What if they’re not? You need a process that finds inefficient code earlier, and a process to fix the inefficiencies that evade early detection. One process can accomplish both goals.

This is article number two in the Method R Oracle® Performance Monograph series. I hope you’ll enjoy it.

Categories
Blog Posts Videos

Method R Workbench: The Pesky, Intermittent Performance Problem

New Method R Workbench features are always inspired by needs discovered on real projects. Two new features of the soon-to-be-released Workbench 9—the radically faster mrskew utility, and a new trace file cropping utility called mrcrop—make it faster and easier than ever to shred through millions of lines of Oracle trace data to find exactly what you need. In this video, I tell the story of how to get to the bottom of a pesky, intermittent performance problem within just a couple minutes of receiving your trace files.

Categories
Podcasts

Cary Millsap it42it Interview

On January 27, my dear friend Mogens Nørgaard hosted me for a 1:39:13 chat, which he flatteringly called “Cary Millsap—the master thinker of application performance and more.” It’s a long, wandering conversation that I really enjoyed.

Categories
Oracle Monographs Papers

Solving the Unsolvable Performance Problem

Solving the Unsolvable Performance Problem

How do you solve production performance problems? The method you use may be structurally incapable of helping you find certain types of performance problems. Changing how you look at your system makes all the difference.

Over the past few weeks, I’ve been writing some short articles in a new series that I’m calling the Method R Oracle® Performance Monograph series. Today, I am releasing the first monograph, called “Solving the Unsolvable Performance Problem.” It’s a fast introduction to understanding why my team and I do what we do. I hope you’ll enjoy it.

Categories
Blog Posts

How to Make Tracing Easy

Last month (June 2018), I presented at Kscope the story of how to make it easy to collect Oracle extended SQL trace data, so you can measure exactly how an Oracle-based application consumes its user’s time. The slides are available at SlideShare.net.

Categories
Papers

Thinking Clearly About Performance

Creating “high performance” as an attribute of complex software is extremely difficult business for developers, technology administrators, architects, system analysts, and project managers. However, by understanding some fundamental principles, performance problem solving and prevention can be made far simpler and more reliable.

Categories
Blog Posts

A Model for Predicting Response Times

One of the more challenging types of performance problem is the dreaded scenario in which the problem occurs only intermittently and is difficult to trap with your performance measurement tools. In such a situation, trace data can be an irreplaceable ally, allowing you to understand even phenomena that you’ve not yet actually measured.

Categories
Release Announcements Videos

Profiler 6.0

Method R Profiler is a software tool for measuring Oracle user response times. Version 6 is our biggest upgrade in ten years. You’re going to love what we’ve done.

Categories
Blog Posts Videos

Why You Need a Profiler for Oracle

If you use Oracle and you care about performance, then you need a profiler for Oracle. This video, created and narrated by Cary Millsap, explains why.