Re: TKPROF is taking a long time
Date: Wed, 13 Aug 2008 16:07:03 -0600
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 <oratips_at_gmail.com>:
> Trace file size 74 GB.
> Oracle 184.108.40.206 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