Re: Trace Programm

From: Keith Jamieson <jamiesonk_at_phoenix.ie>
Date: 2000/07/13
Message-ID: <8kke24$rpm$1_at_kermit.esat.net>#1/1


What about ALTER SESSION SET SQL_TRACE = TRUE;

You can also turn tracing on or off for other sessions using the

dbms_system.set_sql_trace_in_session(sid,serial#,TRUE/FALSE);

Randy Reiter wrote in message <8kivbc$oo7$1_at_slb7.atl.mindspring.net>...
>Refer to http://www.sqlpower.com
>
>The Zero Impact Sql Monitor will capture all SQL with its performance.
>
>Christian Gauler <Christian.Gauler_at_de.bosch.com> wrote in message
>news:8ki2qj$3vu$1_at_proxy2.fe.internet.bosch.de...
>> Hello,
>>
>> whats about a SQL-trace Programm in Oracle where I can see what the
 Server
>> is doing like in MS-SQL Server? I have Oracle 8.0.5 Enterprise Edition
 and
>> can't find it!! Can somebody help me.
>> Thanks
>>
>>
>
>
Received on Thu Jul 13 2000 - 00:00:00 CEST

Original text of this message