top of page
  • Writer's picturekyle Hailey

Method-R Tools


See: Pythians Blog on Method-R tools

Method R Tools

  1. MR Trace ($49.95) – automatically creates, collects and manages trace files for queries run in Oracle’s  SQL Developer using extended tracefile options targeted at collecting pertinent performance information for optimizing SQL statements.

  2. MR Tools (starting at $397)

mrskew – your trace file profiler and data miner, the core MR Tools product, check out Karl Arao’s examples

other tools

  1. mrls – trace file lister, examples, list trace files sorted by  LIO or sorted by rows returned

  2. mrcallrm – trace file cropper – retaining required info and filtering undesired

Trace file timings:

  1. mrtim – timestamp converter

  2. mrtimfix – your trace file tim value fixer, fix 11gR1 bug in trace files & change timing to UNIX epoch

  3. mrnl – pre-pend lines in trace with line #, time, duration and other options as well

  4.  Method R Profiler (starting at $1,180) 

Is like the gold standard for the Method R tools . The profiler takes all the know how and analysis and wraps  it up in a clean crisp html UI that makes for easy browsing , exploration and analysis

I look forward to blogging soon on some of the innovative and powerful features of Method R Profiler

A quick summary of things in the report

1. Task-Level Profiles
1.1 Profile by subroutine
     events like:
      db file sequential read
      db file scattered read >
   spark line
   table , each line is a bucket between 1us - 1000 secs, orders of 10
      call count
      total seconds
2.2 next subroutine

3. Contribution to Subroutine by Statement
3.1 Statement Contributions to <>
     statement text (with sql hash)
       seconds duration
     drill down to stats
3.2 next subroutine

4. Statement Detail
4.1 Statement Report for <>
   Oracle hash value:
   Full statement text: drilldown
   Re-use: # distinct text
   Text size: x lines, y bytes
   # of distinct plans: X
   Optimizer goals:
   response time contribution:
4.1.1 Profile by Contribution to Parent Cursor
4.1.2 Profile by Subroutine
     waits, CPU, time by
     seconds, count, mean, min, max, skew sparkline
4.1.3 Profile by Database Call
        beween calls
        cursor close
       rwos processed
       bufer cache access total
      Library cache misses
4.1.4 Execution Plans and Placeholder Values
      Execution plan
        seconds for row !
        seconds including descendents
        rows returned
        CR LIOs
        PIOs read
        PIOs writes
4.1.5 Statement Text
4.2 ... next statement ...
5. Configuration information
0 views0 comments

Recent Posts

See All
bottom of page