Re: Is SET_SQL_TRACE_IN_SESSION one shot?

Hi.

 I think is's UNIX problem and NOT Oracle's.  How you are moving the files ? ( I just make a

    cp <filename>.trc <filename>.trc_old and let Oracle to reuse   <filename>.trc file ).

 HTH. Michael.

In article <8sl7ue$l72$1_at_nnrp1.deja.com>,   Vaughan Jackson <vaughan_jackson_at_my-deja.com> wrote:
> Ah-ha! I have just realized what has been happening. Perhaps
> this was obvious to you Michael, but it was definitely
> a surprise to me: when I move the files, Oracle keeps
> track of them, and then re-writes them in the new location
> when I turn SQL trace on again. Impressive!
>
> Thanks,
>
> Vaughan.
>
> In article <8sl3hr$heh$1_at_nnrp1.deja.com>,
> Vaughan Jackson <vaughan_jackson_at_my-deja.com> wrote:
> > Hi Michael,
> >
> > Thanks for this idea. However, I have been moving the trace files
> > as soon as I turned off tracing, and yet I don't see any new
> > trace files being created when I turn the tracing on again.
> >
> > Could it be that Oracle is somehow getting confused by the absence
> > of the files it was previously writing to?
> >
> > Vaughan.
> >
> > In article <8skvgf$dqs$1_at_nnrp1.deja.com>,
> > Michael Bialik <michael_bialik_at_my-deja.com> wrote:
> > > Hi.
> > >
> > > I think that your problem is a bit different:
> > > Actually you are turning the TRACE on and OFF, but the results
 are
> > > written to the same trace file ( it's name is based usually on
> > > sid/pid ).
> > > Restarting the instance forces user to start a new session and
 as
 a
> > > result you get another trace file.
> > > Copy your trace file after switching the trace off to another
> > > location ( or rename it ) and start the trace again.
> > >
> > > HTH. Michael.
> > >
> > > In article <8skrhh$a51$1_at_nnrp1.deja.com>,
> > > Vaughan Jackson <vaughan_jackson_at_my-deja.com> wrote:
> > > > Hi,
> > > >
> > > > I have been using dbms_system.set_sql_trace_in_session to turn
 tracing
> > > > on and off for other user sessions. However, it seems that I can
> > > > only turn these traces on and off ONCE. If I want to do it
 again,
> > > > I have to restart the Oracle database.
> > > >
> > > > Has anyone else encountered this problem? Is there a workaround?
> > > >
> > > > Thanks,
> > > >
> > > > Vaughan Jackson.
> > > >
> > > > Sent via Deja.com http://www.deja.com/
> > > > Before you buy.
> > > >
> > >
> > > Sent via Deja.com http://www.deja.com/
> > > Before you buy.
> > >
> >
> > Sent via Deja.com http://www.deja.com/
> > Before you buy.
> >
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Fri Oct 20 2000 - 14:22:44 CDT