Re: segmentation fault running tkprof

Bricklen wrote:
>
> 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

I've occasionally had tkprof's go bust on very large trace files. Maybe play with 'split'

hth
connor

-- 
=========================
Connor McDonald
http://www.oracledba.co.uk

"Some days you're the pigeon, some days you're the statue"