method-r.com

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. Oracle's tkprof tells you only a fraction of the story. 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. Read more...

The Method R Profiler is software that makes simple work of knowing exactly why your application consumes the response time it does. With minimal training, a Method R Profiler user can—in just minutes—identify the root cause of an Oracle-based application performance problem, propose sensible solutions to it, and predict the end-user response time impact of each proposed solution.

Within one minute of installation the Method R Profiler exceeded all expectations. We went live with a new warehouse management system this Friday because all of the tuning was done ahead of time. The Method R Profiler pointed out all of the application inefficiencies which we turned over to the vendor. They were able to fix the ones with the largest impact on the online response times. That gave our management the confidence they needed to make the go/no-go decision. Until I got the Method R Profiler we were looking at postponing it until next quarter. I pity the poor souls that have to optimize in mere mortal ways.

Tony Aponte / Clearwater, Florida

The SLA manager automatically records response times of business tasks and allows you to answer questions like, "What percentage of 'Book Order' button clicks executed over the past month have returned in 2 seconds or less?" Or, "Given current trends, when will our 99th percentile response time of 'Book Order' exceed 2 seconds?" Read more...

ILO, the instrumentation library for Oracle, is an open source project directed by Method R Corporation developers. It contains PL/SQL procedures for measuring tasks using Oracle extended SQL trace. The procedures are installed and compiled in the target Oracle instance and can be called by code written in any language that has access to the Oracle database tier. ILO is fully integrated with the Method R SLA Manager, which allows you to organize and analyze response time data for your entire application system. Read more...