Utilities

A package of two functions to sort collections, including support for descending and distinct sorts. Works with versions from 9i Release 2 onwards but can be easily edited to support 8i. November 2009

A utility to provide the CBO with the correct cardinality of small collections used in TABLE() queries (such as variable in-lists). This helps to achieve better execution plans without having to use the undocumented CARDINALITY hint. Supports versions from 10g onwards. November 2009

Procedure to dump the contents of a table or the results of a query to flat file. July 2009

A package to capture and report separate INSERT and UPDATE rowcounts from a MERGE statement. July 2009

A utility to add parent ID and execution order information to plans reported by DBMS_XPLAN. The XPLAN package includes DISPLAY, DISPLAY_CURSOR and DISPLAY_AWR wrappers for use in exactly the same way as their DBMS_XPLAN equivalents. In addition, a free-standing SQL script for DISPLAY_CURSOR output is provided for environments where XPLAN can't be created. Supports versions from 10g onwards. January 2009

A variation on Jonathan Lewis's SNAP_MY_STATS package to report the resource consumption of a unit of work between two snapshots. Designed to work under constrained developer environments, this version has enhancements such as the option to report on specific statistics. January 2009

Four variations on Tom Kyte's invaluable runstats utility that compares the resource consumption of two alternative units of work. These versions are designed to work under constrained developer environments and build on the original with enhancements such as "pause and resume" functionality and the option to report on specific statistics. January 2009

A simple package to start and maintain a session-based counter. Useful for debugging and instrumentation. May 2008

Two versions of an application to encapsulate the data dictionary views that have LONG columns. LONGs are converted to CLOBs in pipelined functions, enabling us to search, copy and manipulate these columns with string functions. A static version supports 9.2 and 10.1 and a dynamic ANYDATASET version supports 10.2 onwards. September 2007

A simple package to output the elapsed time between two points. Supports versions from 8i onwards. March 2007