Re: Oracle Trace File without recursive calls

Hello Lothar,

> I believe it would help to exclude recursive calls from the raw trace.

You can do that very easily with Events++ in Oracle's kernel debug, diagnostics & tracing, e.g. like this ...

SQL> alter ... set events 'sql_trace {pgadep: exactdepth 0} plan_stat=all_executions,wait=true,bind=true';

Best Regards
Stefan Koehler

Independent Oracle performance consultant and researcher Website: http://www.soocs.de
Twitter: _at_OracleSK

> Lothar Flatz <l.flatz_at_bluewin.ch> hat am 05.10.2020 16:42 geschrieben:
>
>
> 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