Re: can't get new trace file against the same SPID (8.1.7, Windows 2000)

"Jonathan Lewis" <jonathan_at_jlcomp.demon.co.uk> wrote in message news:bq9mmk$bpj$1$8300dec7_at_news.demon.co.uk...
>
> With 8.1.7 you can use the
> alter session set tracefile_identifier = 'something';
> call. This closes the old tracefile properly and you
> can safely delete it. You can then set the tracefile
> identifier back to null to re-open the new one if
> you want, but it's much easier to find trace files with
> useful bits in their names. Also you can do this sort of
> thing:
> alter session set sql_trace = true;
> alter session set tracefile_identifier = 'part1';
> do some work
> alter session set tracefile_identifier = 'part2';
> do some work
> alter session set tracefile_identifier = 'part3';
> exit
> and get three separate trace files with particular bits
> of the session in them.
>
> This doesn't work with MTS (shared servers)
>
> --
> Regards
>
> Jonathan Lewis
> http://www.jlcomp.demon.co.uk
>

Thank you Jonathan, this sounds interesting! I don't remember having seen this parameter before, at least not in Tom Kyte's book, he explains how to retrieve the SPID and other parameters but not this one.

Bye,
Flavio Received on Sat Nov 29 2003 - 08:11:40 CST