Oracle trace files give you incredibly rich, high-resolution performance information, but tracing creates so… much… data. You can’t possibly manage it all without great tools. Method R Workbench 9 makes working with trace data quick and easy, even if you’re staring down thousands of trace files.
The new Method R Workbench 9 is the world’s first Oracle trace file management system. It helps you filter through gigabytes of trace data, spread across thousands of files, to find what you need quickly and easily. Welcome to the world of big performance data.
Here are some highlights:
- Know more, earlier. The first change you’ll notice is the new CPU, LIOs, PIOs, RTs, and Rows columns in the files pane—all sortable. These make it easier for you to know which trace file to drill into first. And we’ve added EXEC call counts to more sections in the profile report. Because it makes your analysis go faster.
- Read your trace files like a book. Significant improvements to the English narrative in the Method R Profile reports make it easier than ever to understand the stories that your trace files are trying to tell you. The reports give you even more guidance, even in those tricky cases where the trace file just makes no sense.
- Find what you need. The new mrcrop utility helps you isolate the trace data for your individual user experiences, even if your application is difficult to trace—because of connection pooling, multiplexing, parallel processing, no use of user session handle attributes, or whatever. Instead of worrying about laser-precision tracing, now you can trace your whole database for a few hours and then fish out the details you care about. It’s fast, even if you’re working with thousands of trace files.
- Know when it happened. The new mrwhen utility makes it easy to see exactly when something happened in a trace file. This makes your trace data directly relatable to your users’ experiences, and to your other diagnostic tools.
- Fast. So you can cope with thousands of files. Does it seem like every time we release, we make something faster? Well, we do. And it never gets old. This time, mrskew and mrls are about 20× faster than before. And we’ve multi-threaded our already ridiculously fast profiler, which means the Workbench can gobble trace files at an incredible pace. These things make a huge difference: faster software means faster progress. Besides, faster is just way more fun.
Let us open your eyes to a new world, a world in which you can see where all your application’s time is going.