Re: tkprof causes segmentation error on UNIX

I faced the problem on ORACLE 7.3.2.2 (which is buggy) and also 7.3.2.3 which is supposedly bugfree (?). Talking to ORACLE support gives this workaround.

After doing the sql_trace=true (either on a session or in the inSID.ora file) and executing your query the FILE.trc is generated. Now you have to run this on the trace file (FILE.trc)

        grep -v APPNAME FILE.trc > tmp.trc
Run your tkprof on this tmp.trc and you will be OK

Another solution is to
1. Set AUTOTRACE ON (Assuming that you have the PLUSTRCE role on thru a script called PLUSTRCE.sql)

        This will automatically give you some of the stats on your query.

Any questions, email me.

HTH,
Vikas

In article <2221287A_at_MHS>, <Stefan.Nilsson_at_ellips.sydkraft.se> wrote:
>
>Hello,
>
>When I try to use tkprof on a trace file, I get the following error:
>
>>tkprof ade_ora_15151.trc trace.txt sys=no explain=user/psw
>
>TKPROF: Release 7.1.6.2.0 - Production on Tue Jul 29 08:17:03 1997
>
>Copyright (c) Oracle Corporation 1979, 1994. All rights reserved.
>
>Segmentation error (core dumped)
>
>
>What happened ? Could anyone help me out here.
>An empty trace file (0 bytes) trace.txt was created and a binary file
>called "core".
>
>Stefan Nilsson
>Sigma Exallon Information AB
>email: stefan.nilsson_at_ellips.sydkraft.se
>

-- 
----------------------------------
Vikas Gautam ,
Sequent Computer Systems,
847-318-0050