Answer. No. The trace file is named after, among other things, the pid
of your shadow process (hmm, never tried it with MTS - let's say a
session identifier) and, unless you disconnect and reconnect, you cannot
change it.
The best you can do is either look for the 'ALTER SESSION' which turns
trace on/off in the file, or possibly execute a
select 'step 1 stops here' from dual;
before turning trace off, to generate markers in your file. The snag is
of course that it will prevent you from using any tkprof sorting option
if you want to keep the steps distinct. Unless you make as many copies
of your .trc file as you have steps, edit each of them and remove
everything which is not relevant to the step before running tkprof, but
is it worth the trouble ?
--
Regards,
Stephane Faroult
email: sfaroult_at_oriolecorp.com
Oriole Corporation
Voice: +44 (0) 7050-696-269
Fax: +44 (0) 7050-696-449
Performance Tools & Free Scripts
------------------------------------------------------------------
http://www.oriolecorp.com, designed by Oracle DBAs for Oracle DBAs
------------------------------------------------------------------
>
> Hi,
>
> Question. Is it possible to have more than one trace-file per
> session ?
>
> e.g. I start a trace on a certain session, stop the trace en analyze
> the results. Later in time, when my procedure has advanced into another
> stage, I want to start a new trace, to analyze that one too. But, I haven't
> succeeded as of yet to start a new trace on a session that has already been
> trace before.
>
> Oraccle 7.2.3 on HP-UX 10.20
>
> Thanx in advance.
Received on Fri May 19 2000 - 06:43:13 CDT
