Categories
Oracle Monographs Papers

Making Sense of Thousands of Trace Files

If you do it right, the overhead incurred by Oracle tracing is imperceptible, so more sites than ever are using trace data as a source for detailed performance data. But what can you do when you end up with thousands of trace files? With Method R Workbench, it’s not a problem.

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

Categories
Oracle Monographs Papers

The Case of the 2× Slower Report

Why does a report run twice as fast on an identically configured sandbox? It’s not the execution plan. Method R Workbench makes it easy to find out.

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

Categories
Oracle Monographs Papers

Making Your Application Easier to Diagnose

It’s easy these days to mine interesting user experiences out of enormous trace data collections. But there’s still value in being able to trace that one user or that one program, right when you need it.

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

Categories
Oracle Monographs Papers

Death to the Health Check… Long Live the Health Check

Better Testing, Better Risk Reduction

I have a long history with conventional database system “health checks.” I don’t like them. I haven’t liked them for a really long time, since about 1997, when I realized that conventional health checks are an inferior way to help customers. There is a better way.

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

Categories
Oracle Monographs Papers

Better Testing, Better Risk Reduction

Better Testing, Better Risk Reduction

When your tests don’t measure your system the way your users will perceive it, you can be headed for big trouble. When you test, you should measure how your application is going to feel to your users. These measurements give you confidence both in the programs you’ve tested, and in the diagnostic process you’ll use later in production.

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

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
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.