Re: tracing of waht the oracle client does.

On 17 Jun 2004 03:56:52 -0700, kw9_at_gmx.de (xkd) wrote:

>Hi,
>
>i have an application running without having acces to th sourcecode.
>This application connects to an oracle server (8.1.6).
>I would like to see each submitted sql-statement of this application,
>and if the sql statement succeeded.
>
>I am able to link c++ - code to this application.
>
>Is there any posibility to be able to trace this database communication ?
>
>Thank you,
> Klaus
>
>please reply to kw9_at_gmx.de

actually many
You could write an after logon on database trigger, with as only statement
execute immediate 'alter session set sql_trace = true'; You could set event 10046 on system level to trace all session like this
alter system set events='10046 trace name context forever, level 8'

You could use oradebug inside sql*plus to set this event for specific session.

8.1.6 was a can of worms, and has been desupported several years ago

--
Sybrand Bakker, Senior Oracle DBA