Re: SQL Trace startup problem

Mark,

        Try using the DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION procedure which can turn tracing on for a given session. This is documented in the server tuning guide. I think that this may only be available in 7.2 or higher.

Regards
Simon Kelly
Database Consultant
ITnet Ltd

Mark Madsen <mark.madsen_at_tswi.com> wrote in article <01bbc440$71a96ae0$1f9afd80_at_solaak79.dial.pipex.com>...
>
> Hello,
>
> Does anyone know of a way to start Oracle's trace for one session from
> another one? I have it turned on for the instance but it is difficult for
> me to identify the point in the TKPROF file that I am interested in. I
 know
> one solution is to use dynamic sql and alter the session but this
 requires
> me to modify all of our packages. It seems to me that a dba would be able
> to modify another users session to turn tracing on and off - but
 apparently
> that is not feasible.
>
> Any ideas????
>
> Mark Madsen
> mark.madsen_at_tswi.com
>
Received on Mon Oct 28 1996 - 00:00:00 CET