You are probably looking for
SQL> exec sys.dbms_system.set_sql_trace_in_session(sid,serial#,true);
This will create a trace file for the session identified by sid and serial#
--
Syltrem
OpenVMS 7.3-1 + Oracle 8.1.7.4
http://pages.infinit.net/syltrem (OpenVMS related web site, en français)
---zulu is not in my email address---
"Carsten Grammes" <cgrammes_at_gmx.net> a écrit dans le message de
news:42a462c9.23489000_at_gandalf.dialogika.de...
> Hello world,
>
> (how) can I monitor the sequence of SQL commands of a session? I'm not
> interested in statistics but in the exact sequence of commands. Can
> this be done with Oracle commands? (I'v found sth. to do this in
> windows at the client side at ODBC level but server would be much
> finer).
>
> Thanks
> Carsten.
>
> ---
> I want to die peacefully in sleep like my grandfather.
> Not screaming in terror like his passengers!
Received on Mon Jun 06 2005 - 12:27:18 CDT
