Re: TKPROF is taking a long time
Date: Thu, 14 Aug 2008 09:22:47 -0400
Thank you very much. yes Truss showed the process worked like heck..
compressing trace file brought the size down to 5 GB from 74GB.
tkprof finished in 30 mts..
thank you all
On 8/13/08, Tim Gorman <tim_at_evdbt.com> wrote:
> 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
> 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
> Quoting Bala <oratips_at_gmail.com>:
> Trace file size 74 GB.
>> Oracle 22.214.171.124 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
-- Bala Rao -- http://www.freelists.org/webpage/oracle-lReceived on Thu Aug 14 2008 - 08:22:47 CDT