Re: Oracle Trace File without recursive calls

OK, thanks Jonathan.

Regards

Lothar

Am 05.10.2020 um 18:07 schrieb Jonathan Lewis:
> James Morle wrote something to do this a long time ago - I don't know
> if it's still available, or whether it's been kept up to date with new
> datatypes.
> Without doing the searches myself I couldn't tell you any more about it.
>
> Regards
> Jonathan Lewis
>
>
> On Mon, 5 Oct 2020 at 15:43, Lothar Flatz <l.flatz_at_bluewin.ch
> <mailto:l.flatz_at_bluewin.ch>> wrote:
>
> Hi,
>
> I am currently trying the process a 10046 trace to generate a sql
> script that does call the non recursive sql in the trace .
> I was trying HammerDB, but that tool is not sophisticated enough.
> I keep getting "Failed to find expected bind variables  ..".
> It seems to have issues if the corresponding parse and bind step
> is interleaved by a recursive call.
> I believe it would help to exclude recursive calls from the *raw
> trace*. (tkprof can excude sys in the output, but not in raw trace).
> Of course it is even better if you know an other tool to use in
> this case.
>
> Regards
>
> Lothar
>

--
http://www.freelists.org/webpage/oracle-l