Re: TKPROF is taking a long time

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
> 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 9.2.0.5 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-l