Re: segmentation fault running tkprof

Thanks Dave and Connor,

I grep'd | wc -l the STAT lines and counted 701, although if you go by STAT #, there were never more than about 40 per #. Split is an interesting idea, and not one I even considered for this problem (having no idea what the problem _was_ !).

As it turns out, today the exact same query's trace file (flushed shared_pool, same values etc) goes through tkprof without a hitch. No parameters or settings were changed, and no os options were changed that I am aware of. Strange....

Anyways, thanks for the tips!

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"
Received on Thu Jul 10 2003 - 09:37:58 CDT