Re: How can I capture the dialog between a client and a server ?

From: Pierre Charpenay <pcharpenay_at_unilog.fr>
Date: Tue, 25 Jan 2000 09:38:52 +0100
Message-ID: <388D611C.248B8FEA@unilog.fr>

Philippe CEROU a écrit :

> We have a AIX 4.2.1 / Oracle 7.3.4.4 and clients under windows 95
> We have a running application on the clients which ask the server for
> informations.
> Is there any method to capture the contents of a request from the client to
> the server (The sql source of the select for example) ?
>
> Thanks...

You can use :

alter session set sql_trace true;

After this command, all the requests passed (and more) will be written in a .trc file
under $ORACLE_HOME/rdbms/log.

Pierre. Received on Tue Jan 25 2000 - 02:38:52 CST