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.
Two or three times in the past twenty years, we’ve created Forum pages where people can ask their Method R support questions, and then people can both see other people’s answers and contribute their own. It has gone kind of like this: Me: I’m going to create a new Method R forum. It will become a vibrant […]
Cary Millsap’s The Method R Guide to Mastering Oracle Trace Data, 2nd edition contains everything you need to know about Oracle trace data—how to collect it and what to do with it once you have retrieved it, using the Method R Workbench software suite. The book creates a scientific basis for understanding why computing systems perform the way they do. It provides comprehensive detail about controlling, […]
The Method R Trace extension for Oracle SQL Developer (versions 4 and 17) makes collecting performance diagnostic data a snap. This quick tour explains.
A couple weeks ago, my friend Bob Rhubart at Oracle dropped me a note asking if I’d like to participate in his 2-Minute Tech Tip series for his blog at OTN.
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.
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.
Do you have SQL in your system that doesn’t use placeholders, like this? [3r3dhkb0z824v] select stuff from t where id=18432... [5wamvs45j6nh4] select stuff from t where id=4286... [ih5x9lgg492nk] select stuff from t where id=329971... Statements like these are generated dynamically by procedural programs written in Java, PHP, C#, etc. (or even PL/SQL if you work really […]
Connection pools help solve a big performance problem, but they also make using trace data more difficult. Method R Tools, part of the Method R Workbench software package, makes it easier to measure individual user response time experiences on connection pooling systems. Now you can look at performance problems the way you’ve always wanted to see them.
Many Oracle educators teach that reducing the number of PIO (“physical” I/O) calls should be the top priority of SQL optimization. However, in our field work, we commonly eliminate 50% or more of the response time from slow Oracle applications, even after they’ve been tuned to execute no PIO calls. The secret is that Oracle LIO […]