There has been a flurry of questions recently, on the Toad For Oracle Forum, about Toad's Trace File Browser (aka TFB) utility. This is something that I find extremely useful in my daily DBA duties, and the bigger the trace file, the more useful I find it.

I have created, mainly for my colleagues' use here at work, a document and a couple of example trace files, which I'm making available for all my Toad "colleagues" wherever you are.

The files attached (somewhere) to this post are held in a single zip file, and are:

  • ToadTraceFileBrowser.pdf the main document which explains just about everything about the TFB. It explains the various tabs, top and bottom of the display, and includes a couple of worked examples.
  • ToadTraceFileBrowser.docx is a Microsoft Office version of the above.
  • DropTable.trc is the example trace file which makes up the first of the worked examples. It allows the viewing of exactly what Oracle does when you ask it to drop a table which has triggers, views and such like, dependencies.
  • FreeSpace.trc is the second example trace file that is worked through in the document. It shows a serious performance problem when running a script against DBA_FREE_SPACE on an 11.2.0.4 database running on Windows.

Hopefully, you will find the attached useful.

Cheers,

Norm. [TeamT]

About the Author

Norm TeamT

I'm getting on in years now, having been in IT for around 30 plus years. I've been in support for most of them too as well as being a developer.