Re: Snooping the SQL issued by a client app

From: frank <fbortel_at_home.nl>
Date: Mon, 23 Oct 2000 15:37:12 GMT
Message-ID: <39F45B68.73806E76@home.nl>

As Niall Litchfield just answered in another thread: <quote>
connect using your prog.
connect using sql*plus and find the sid and serial# from v$session for your

connection
use DBMS_SYSTEM.SET_SQL_TRACE_IN_SESSION for the ODBC program.

</quote>

CUJimmy wrote:

> Thanks Frank - I'll try that.
>
> > Another option would be to set tracing on the server, but that would
> > trace all sql, not only yours.
>
> That wouldnt be a problem as I can run it captive (ie. only "my" client
> running - nothing else). How do I turn on this mode on the Server? Can
> it log the record sets returned on each SQL query too?
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
Received on Mon Oct 23 2000 - 10:37:12 CDT