Re: Tracing client SQL statement
From: Manu <emmanuel.pl.bontemps_at_wanadoo.fr>
Date: Mon, 14 Jun 1999 18:14:21 +0200
Message-ID: <7k39q2$n9m$1_at_oceanite.cybercable.fr>
Date: Mon, 14 Jun 1999 18:14:21 +0200
Message-ID: <7k39q2$n9m$1_at_oceanite.cybercable.fr>
Yes,
with SQL*PLUS can set AUTOTRACE ON (ORACLE 7.3)
To turn on sql trace in session level :
"alter session set sql_trace = true;" (or something like this)
You will have <oraproc>.trc file on your server (in USER_DUMP_DEST
parameter).
Use TKPROF with this file to analyze SQL statements.
Or use one of many tiers product.
Per Sverre Stiansen a écrit dans le message ...
>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 - 18:14:21 CEST