Toad World Blog

Toad Trace File Analyser

Jun 28, 2017 8:59:13 AM by Norm TeamT

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]

Tags: Toad for Oracle

Norm TeamT

Written by 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.

I've been in TeamT for many years, since the team was first set up in fact. I used to have a profile on the Toad World "Experts" page, but the TeamT members seem to have been taken away, and hidden for some reason. ;-)

I run, with my wife, our own software company. I do Oracle and development as required, and Alison does software testing. She's good!

I like reptiles, I used to keep bees but my wife suddenly became highly allergic to bee stings, so I don't keep them any more. I am most definitely a dog person and don't like cats much at all!

My wife says I'm grumpy! She may be right.