Re: Tracing client SQL statement

From: Peter Laursen <ptl_at_edbgruppen.dk>
Date: 14 Jun 1999 09:15:04 GMT
Message-ID: <01beb64f$394be7a0$2c289a0a@apollo>

Hi Sverre
Get the session-id of the client. I use toad - otherwise look at v$session. (v_$session?)
call dbms_system.set_sql_trace_in_session(sid, serial, true) it will generate a rather large and growing file in \rdbms80\trace use tkprof to analyze this file

Beware, Im a newbie - any of the above might be wrong :) Peter

Per Sverre Stiansen <per.sverre.stiansen_at_caa.no> skrev i artiklen <Xz393.110$g17.359_at_news1.online.no>...
> Hi all!
> Any idea how to trace sql statements invoked by a client ?
> Oracle 7.3.3 and SQL*Net v2.3.3
>
> Per Sverre
> per.sverre.stiansen_at_caa.no
>
>
>
Received on Mon Jun 14 1999 - 04:15:04 CDT