RE: RE : Only one trace-file per session ?

Currently we have a parameter set causing my trace files to be a max of 10Mb. This is enough to optimize a particular step in the procedure. Some procedures however run for over 24 hours. It is sheer impossible to trace the entire session because we are talking millions of executes. (I hit the limit of 10 Mb mostly after about 5 mins) Anyways, I figured I'd start a trace, stop it after a while, tkprof the trc, jump to conclusions like I always do en start a new trace after a while. True I can't change the name, but don't need to because the old one can be overwritten.

Guess I want to much.

Thanx for the info.

Kirsten

> -----Original Message-----
> From: Stephane Faroult [SMTP:sfaroult_at_oriolecorp.com]
> Sent: Friday, May 19, 2000 12:43 PM
> To: oracle list; Weerd de E.C. Kirsten
> Subject: RE : Only one trace-file per session ?
>
> 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 - 07:58:03 CDT