Re: segmentation fault running tkprof

From: Dave Hau <davehau-no-spam-123_at_no-spam.netscape.net>
Date: Thu, 10 Jul 2003 04:46:23 GMT
Message-ID: <zc6Pa.668$8f4.583@newssvr16.news.prodigy.com>

"Bricklen" <fake_at_email.com> wrote in message news:3F0C2E0F.21077DAA_at_email.com...
> 8.1.7, linux
>
> Situation: ran a relatively complex query using 6 bitmapped columns, on
> a partitioned table, and with autotrace on. That's fine.
> Prior to running, set "alter session set events '10046 trace name
> context forever, level 8'", then ran tkprof on the 22MB tracefile. 2
> seconds after starting tkprof, up pops a message saying 'segmentation
> fault', and quits.
>
> I googled up a couple of notes about a bug (way in back in 7+) that said
> to try "grep -v APPNAME tracefile.trc > newfile.trc" but that had no
> success.
>
> Anyone have any suggestions on how to work around this, or encountered
> this before?
>
> Cheers,
>
> Bricklen

Could be this bug:

Bug 1354942 Fixed: 8172
a.. Dumps / Abends
TKPROF may dump if "STAT" lines are over 79 characters long. Workaround:
Edit the raw .trc file so that no STAT line is over 79 characters.

Try applying 8172 or later patch.

Cheers,
Dave Received on Wed Jul 09 2003 - 23:46:23 CDT