Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Tracing client SQL statement

Re: Tracing client SQL statement

From: Craig Brady <cpbrady_at_frontiernet.net>
Date: Mon, 14 Jun 1999 21:54:03 -0400
Message-ID: <7k4br1$1msu$1@node17.cwnet.frontiernet.net>


Per..
Are you looking for the currently executing SQL statement for a client? Or are you looking for all statements executed by all clients? There are ways to access v$ and other 'reserved' tables to do this...but it depends on what you are looking for.
Send e-mail to: cpbrady_at_frontiernet.net

Craig Brady
Talisman Technologies Inc
Specializing in Oracle/VLDBs/Data Warehousing <><><><><<><><><><><><><><><<<><><><><><><

Per Sverre Stiansen wrote in 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 - 20:54:03 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US