Re: Snooping the SQL issued by a client app

From: <argosy22_at_my-deja.com>
Date: Thu, 02 Nov 2000 23:26:12 GMT
Message-ID: <8tst6b$199$1@nnrp1.deja.com>

Perhaps this might help you. You would have to run it from another session as the other program was running. It will show the user who executed it.

  1  Select     username,
  2             SID,

  3 SERIAL# ,
  4 osuser,
  5 v$session.sql_ADDRess,
  6 sql_text
  7 from V$SQLarea,
  8 v$session
  9* where V$SQLarea.ADDRESS = v$session.sql_ADDRess

this one will show even more code that was executed. SELECT sql_text FROM v$sqlarea WHERE executions > 0

It won't help you perfectly reproduce it, but it could help you figure out the big picture.

Good luck

In article <8snnb8$l99$1_at_nnrp1.deja.com>, CUJimmy <public_at_asd-group.com> wrote:
> I'm not a database/Oracle expert, but I have a custom 16-bit Windows
> program which extracts data from an Oracle 8i database (through SQL-
> net) to local files. It does this using embedded SQL and calls some
> stored procedures in the database.
>
> I need to find out what SQL it generates (directly or via stored
> procedures) while it runs, so I can ultimately figure out what it
does
> and write an ODBC version of the same thing (unfortunately it has no
> docs or source code).
>
> Could someone tell me if there is a way to snoop the program in this
> manner? I'm hoping that there is some Oracle or SQL-Net mode, or
other
> tool, which can dump the SQL sent from the client, or something like
> that.
>
> Thanks for any suggestions!
>
> Sent via Deja.com http://www.deja.com/
> Before you buy.
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 02 2000 - 17:26:12 CST