Method R Tools version 3.0 introduces dozens of new features to the utilities, but the big news is the new graphical user interface that makes using mrskew and mrls in your performance measurement projects as easy as a click! Visit our Method R Tools Change Log for the complete list of new features.
What’s in a trace file? Incredible things: the reason your report is slow, proof that your SAN is falling down on the job, and a thousand other things you need to know but that none of your other tools can tell you. Oracle’s tkprof tells you only a fraction of the story. The MR Tools suite of software tools helps you get everything your trace files have to offer. They’re great companions for users of tkprof or Method R Profiler.
MR Tools is an all-in-one ETL + BI solution for Oracle database trace files.
Chief Technical Officer
The Pythian Group
Method R Software Information Library
Check out our library for more information about Method R software:
Buy MR Tools now
In version 3.0, you can run the stars of the MR Tools suite—mrls and mrskew—with just a click of your mouse. You can also run any tool in the MR Tools suite directly from your command line, in the spirit of Unix filters. Each tool has a singular focus with lots of powerful options, which means that each tool works in harmony with other filters—think sort, grep, head, more, etc.—to exploit the full value of the powerful operating system scripting environment you already know and love.
The MR Tools suite runs on Linux, Mac OS X, Solaris SPARC, and Microsoft Windows. It consists of the following software tools:
- mrskew — your trace file profiler and data miner
- You won’t believe how much data is tucked away into a whole directory full of trace files. Trace files contain a record of where your Oracle Database has spent your time, and mrskew is the key to getting that information out in a way that anyone on your team can understand. It is the most remarkable piece of software that we’ve ever created. It can create response time profiles, for one file or a whole directory. It can drill into details like nothing you’ve ever seen. What are the end-to-end response times for your users’ experiences? With mrskew, you can know, even in a connection pooling application architecture.
That’s not all. Which bind value combinations account for your longest execution times? In which service/module/action combinations do your users spend the most time? Which trace files account for the most time spent waiting for latch acquisitions? Which database file has the worst disk I/O call latencies? Which SQL statement accounts for the most time spent parsing? Which array fetch size accounts for your biggest consumption of response time? How many library cache misses have occurred on EXEC calls in sessions traced between Wednesday and Saturday? The answers to these questions and thousands more are just a click away.
- mrls — your trace file lister
- Have you ever sat staring at a directory full of a thousand trace files, unable to figure out which one you needed to open next? Do you want to know which trace file accounts for the most response time? Which file accounts for the largest LIO count? Which file accounts for the most rows returned? With mrls, you’re only a click away from knowing.
- mrcallrm — your trace file correction fluid
- When you use trace data to profile end-user response time, it is vital that your trace file contain exactly the right trace lines. But sometimes, it’s nearly impossible to start or stop the tracing at exactly the right instant, so you end up with more trace data than you really want, and that throws off your profile. With mrcallrm, you can fix your trace file to make the unwanted lines go away. It’s harder than it looks, because for every line you delete, you have to adjust the tim and timestamp values throughout the remainder of the file. But with mrcallrm, it’s all automatic.
- mrtim — your trace file tim calculator
- Did you ever wonder what time that tim value on a line of trace data represents? With mrtim, you can convert tim values to timestamps and timestamps to tim values. Now you can join back into your Oracle Active Session History data to see what was going on in your system exactly when that trace file line was emitted.
- mrtimfix — your trace file tim value fixer
- Do you suffer from Oracle bug 7522002, an 11gR1 bug that corrupts the tim values in your trace files? It makes your tim values zigzag back and forth in time between your database call lines and your operating system call lines, which makes using a proper profiling tool on your trace data impossible to do. With mrtimfix, you can fix them right up. You can even convert the 1,024-nanosecond tim values that Oracle uses on some ports to proper Unix epoch microsecond values that all your tools can understand.
MR Tools: see your Oracle trace files in stunning high-definition.
Click the following links to see the MR Tools product manual pages.
Product Change Log
Click here to view our MR Tools bug fixes and new features.
There are two types of MR Tools licenses. A per-person (multi-platform) license permits one specific person to run a tool with any login id, on any system, anywhere. A per-userid license permits one specific person to run a tool using a single login user id on a single machine (either real or virtual). If you’ll run MR Tools on more than two login ids (for example, on more than two systems), then the per-person license is the better license for you.
Price is $997 usd per one-person license, or $397 usd for a limited one-userid license. These prices include maintenance and support for one year.
Buy MR Tools now