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

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

  The educated person is not the person
  who can answer the questions, but the
  person who can question the answers -- T. Schick Jr


One-day tutorials:
http://www.jlcomp.demon.co.uk/tutorial.html


Three-day seminar:
see http://www.jlcomp.demon.co.uk/seminar.html
____UK___November


The Co-operative Oracle Users' FAQ
http://www.jlcomp.demon.co.uk/faq/ind_faq.html


"FC" <flavio_at_tin.it> wrote in message
news:VQQxb.22974$AX1.894445_at_news1.tin.it...


> Hi all,

> I noticed that I can't get Oracle to create a new trace file against the

> same SPID more than once.

> For instance, if I enable sql_trace, then disable it and delete the

> resulting trace file, I can't get any new trace file against that SPID,

> unless I disconnect the session and reconnect.

> If the job I want to trace is run in batch mode, I can't trace it any more

> if I deleted the original trace file, unless I bounce the instance.

> The fact I am deleting the trace file while it is closed, that is after

> issuing alter session set sql_trace= false, seems to be irrelevant.

> I cannot understand why Oracle can't just create a new file with the same

> name.

>

> Any thoughts?

>

> Bye,

> Flavio

>

>