Re: TKPROF is taking a long time

From: Tim Gorman <>
Date: Wed, 13 Aug 2008 16:07:03 -0600
Message-ID: <>

Since you're on Solaris, you can use the "truss" command against the TKPROF process to see if it is really "hanging" or whether it is just working like heck...

On a 74 Gb trace file, I suspect that the latter is the case. I imagine you're just going to have reduce the size of that file somehow (i.e. UNIX "split" command comes to mind) or just wait until TKPROF chunks through it all...

Quoting Bala <>:

> Trace file size 74 GB.
> Oracle on Solaris 2.10
> Running TKPROF is taking a long time -- seems like it is hanging -- any
> suggestions ?
> Appreciate any ideas/suggestions
> Thanks in advance
> --
> Bala Rao

Received on Wed Aug 13 2008 - 17:07:03 CDT

Original text of this message