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 220.127.116.11 database running on Windows.
Hopefully, you will find the attached useful.