These scripts will be of interest to those who are interested in learning more about Oracle internals. One way to learn is to build a test case and then examine the contents of the redo log files to see what redo was generated. These scripts are intended to support that sort of experimentation.

The dump_logfile.sql script dumps the contents of a redo log file to the trace file for the current process in a human (?) readable format. One interesting thing about this script, even if you're not interested in the internals of log files, is that it demonstrates how to execute code conditionally in an SQL*Plus script despite not having an IF statement.

The redo_time.sql script can be used to express times in decimal using the special formula required when specifying minimum and maximum time boundaries for the dumping of redo.

The scripts are available at http://www.ixora.com.au/scripts /dumps.htm#dump_logfile and http://www.ixora.com.au/scripts/du mps.htm#redo_time respectively.