Categories
Books

“Faster: How to Optimize a System”

Faster: How to Optimize a System is the latest book by Cary Millsap with Jeff Holt. It’s a book for anybody who yearns to understand why systems in this world perform the way they do, and what you can do to improve them.

“I can’t believe I was in my forties the first time I saw how to optimize a system the way Cary and Jeff do it. Now, it doesn’t even make sense to me that anyone would try it any other way.”

Richard Russell, former 7-Eleven enterprise architect

Faster is available today.

Categories
Workbench Release Notes

Workbench 9.2.1.2

  • 8405: mrskew now can read trace files with missing SQL statement text.
Categories
Release Announcements

Workbench 9.2

Method R Workbench 9.2 adds bug fixes and exciting new features to 9.1. The application now runs on any version of Java at or greater than Java SE 8. We have replaced the muddy zebra-striping in the files pane and the HTML5 output with a cleaner, more elegant, Tufte-inspired three-row banding method. Table headers in the HTML5 output are now sticky, which means they always remain conveniently in view, regardless of how many rows a table has (it’s especially convenient for analyzing long execution plans). And the Workbench application takes less time to start up in this release, especially when you’ve been working with lots of trace files.

Categories
Workbench Release Notes

Workbench 9.2.0.23

  • 8404: Updated the installation instructions URL in the application’s “Startup Error” dialog.
  • 8401: Made column widths consistent in the mrskew man page all.rc example on p14.
  • 8400: Workbench will now run with any version of Java from 1.8 onward.
  • 8395: All Windows binaries are now signed.
  • 8384: Eliminated mrskew $t alias for $tim.
  • 8377: Added mean, min, and max information to profile by subroutine total lines.
  • 8374: Table headers are now sticky, which means they always remain conveniently in view, regardless of how many rows a table has.
  • 8373: Moved the skew column in profile by subroutine tables to the tail of each row, so that min and max data will be adjacent to each other.
  • 8370: Eliminated redundant $oraver mrskew variable, and fixed $oracle_release variable to recognize new Oracle Database 19c trace file version stamps.
  • 8361: Replaced zebra-striping of the files panel with a cleaner, more elegant, Tufte-inspired three-row banding method.
  • 8355: The Method R Workbench application now allows you to open a profile report by clicking on an ID or Size column value.
  • 8322: Changed Evaluate › Run menu option name to Evaluate › Run Action.
  • 8319: Profiler error messages generated by the app are now separated by a newline.
  • 8313: Eliminate unused aliases $h, $cur_id, $cid, and $ses_id.
  • 8307: Workbench now recognizes Oracle Database version info printed in the new 19c format.
  • 8304: New mrskew prepackaged action answers the question, “How much time would an execution have spent reading blocks if it did no block re-reads?”
  • 8301: If you specify mrskew –rc=file for a file that does not exist, mrskew will now terminate immediately upon parsing the command line and not run the report.
  • 8299: The “Duration by SQL ID”, “LIO count by SQL ID”, and “PIO count by SQL ID” reports now all use the –alldepths command line option.
  • 8297: mrskew now interprets ERROR lines as dbcalls.
  • 8296: Added new mrskew $oerr expression variable.
  • 8292: Fixed a bug that could cause an “can’t build document from input xml file” error.
  • 8291: Fixed a bug that caused Preferences panel tabs to render illegibly.
  • 8283: Removed the .zip item from mrprof man page Description section, and –first_member and –member options, because mrprof does not process .zip archives.
  • 8282: Updated mrwhen man page with information about new features.
  • 8281: Fixed a bug causing the Workbench application to change the cursor to a “Mickey hand” in some situations where clicking is not allowed.
  • 8280: Fixed a bug that would cause a reload of a relocated file to produce a “can’t open file” error.
  • 8276: Workbench startup and the View › Clear Application feature now take less time than before, especially for a database with many loaded files.
  • 8273: Added mrprof –load and –create options.
  • 8272: Added documentation for mrprof –workers option to the mrprof man page.
  • 8271: Added new $module_id and $action_id variables, and eliminated the now-ambiguous aliases $service, $serv, $module, $mod, $action, and $act.
  • 8261: Fixed a bug that caused the Workbench application on macOS not to load files dropped onto a Workbench icon.
  • 8250: mrskew now exposes a mrtime function and variables $time0 and $time1.
  • 8249: Fixed a bug causing mr1011 not to properly scale c values on RPC EXEC lines.
  • 8248: Cursor no longer changes to a hand when hovering over a File value when the file does not exist.
  • 8247: New “Copy selected file rows to output (shift-click for CSV)” button function creates CSV output.
  • 8245: Moved Workbench installation instructions from https://method-r.com/man/mrworkbench to https://method-r.com/software/workbench/install.
  • 8241: Clarified and simplified some mrwhen warning messages.
  • 8240: mrprof now warns when you try to process a file that mrprof is not designed to process.
  • 8239: Added all the content (prerequisites, installation, troubleshooting, …) from https://method-r.com/man/workbench to https://method-r.com/software/workbench.
  • 8237: Documented instructions for activating a Workbench license key at https://method-r.com/software/workbench/install.
  • 8235: Clicking on a trace file’s Directory value now opens the file manager, even if the file’s folder no longer exists.
  • 8228: Fixed a bug causing mr1011 not to scale c values correctly.
  • 8227: Updated mr1011 man page with information about new features.
  • 8226: mr1011 now appends a tim field to each WAIT line in pre-10g trace files.
  • 8225: Workbench application now makes a success sound when a file load is complete.
  • 8222: Method R Workbench 9 is certified to run on macOS 11.1 Big Sur.
  • 8221: Added the mr1011 manual page to the application Help menu.
  • 8220: Added mention of the mrcrop utility to the mrprof man page.
  • 8216: Offset the stateful “Show mrprof details” button from the other buttons in the main toolbar, matching the spacing of the stateful “Show example output” button in the action pane toolbar.
  • 8215: Re-labeled hover hint from “Elide mrprof details” to “Hide mrprof details”.
  • 8210: Modified Workbench icon to meet macOS 11 specifications.
  • 8208: Added new mr1011 –scale option.
  • 8207: Fixed a bug causing the “# mr1011…” comment line not to be written to the output.
  • 8206: Fixed a bug where CLIENT, ACTION, and MODULE values included characters introduced in 18c that aren’t part of the actual values.
  • 8203: Fixed a bug causing mrprofk not to properly recognize the end of a SQL statement in a PARSE ERROR section.
  • 8192: mrcrop now denies any attempt to overwrite a file.
  • 8191: Improved the performance of mrwhen –tim for large files.
  • 8190: Added new mrwhen –drift and –drift-only options.
  • 8184: Fixed a bug causing the Workbench application to miscalculate how much time is remaining on the license key.
  • 8183: Fixed a bug causing mr1011 not to emit the sqlid field on PARSING IN CURSOR lines.
Categories
Videos

Method R Workbench Video Tips

A collection of short video tips to help make the most of your Method R Workbench experience.

  1. Method R Software Workflow (1:54)
  2. Automatically Opening Profiles (1:43)
  3. The “Automatic Transmission” (1:36)
  4. The “Show mrprof details” Button (1:32)
  5. Which File to Open Next? (1:03)
  6. The Pig Nose (1:25)
  7. Connection Pools (2:21)
  8. Locale Code (0:54)
Categories
Release Announcements

Trace 21.2

Method R Trace 21.2 is ready for Oracle SQL Developer 21.2. We’ve created a whole-new, even more efficient design for Method R Trace, where all the commonly-used controls are now on the toolbar. We’ve added a new STATISTICS_LEVEL control on the Preferences page, and we’ve simplified the process of creating the Oracle Database objects required by the product.

Categories
Trace Release Notes

Trace 21.2.0.7

  • 8360: Simplified the Oracle Database object installation process.
  • 8343: Database object installation script no longer complains when the METHODR user already exists.
  • 8342: Added a new “Statistics level” preference to the Preferences panel, and orthogonalized the “Bind values” preference to have the same type of widget as the other preferences.
  • 8336: Changed the name of the extension in the View menu from “Trace File Downloads” to “Method R Trace”.
  • 8329: We’ve created a whole-new even more efficient ultra-clean design for Method R Trace. The files pane, which had always been a redundant subset of your Finder/Explorer, is gone, replaced by a status pane that informs you about your most recent activity.
  • 8328: Updated help text to refer to the central authoritative documentation source at method-r.com.
  • 8326: Replaced the big “Method R Trace Enabled” and “Method R Trace Disabled” toggle button with a tidy green/clear lamp indicator on the toolbar.
  • 8320: Simplified the Preferences › Method R Trace › Setup panel by eliminating the redundant “Enable SQL tracing and file downloading” option.
Categories
Testimonials

Oracle tuning assignments can be pretty easy

Categories
Blog Posts Videos

Some things you probably didn’t know about Oracle tracing (Chicago edition)

Today, I had the honor of speaking online to the Chicago Oracle Users Group in their “20 in 2020” webinar series. In this presentation, I talk about why it’s OK to trace everything on your system and how to do it safely, and I explain why you’d want to do that in the first place.

Some things you probably didn’t know about Oracle tracing
Categories
Testimonials

Method R for capacity planning

The practical approach Cary explained for capacity planning brought to light a whole other application for the tool.

Nancy Spafford · DBA and Tech Lead · Lawrence Livermore National Laboratory · Livermore, California