Re: Realtime SQL Trace like MS SQL Server

From: Thomas Hase <tohas_at_freenet.de>
Date: Sat, 19 Mar 2005 19:53:05 GMT
Message-ID: <423f80a0.84514500_at_news.t-online.de>


[Quoted] [Quoted] On Sat, 19 Mar 2005 18:22:47 -0000, "Niall Litchfield" [Quoted] <niall.litchfield_at_dial.pipex.com> wrote:

>"Thomas Hase" <tohas_at_freenet.de> wrote in message
>news:423e64d3.77396843_at_news.t-online.de...
>> Hi NG,
>>
>> I'm looking for a possibility to show all SQL-Statements (testsystem)
>>
>> in realtime. (Ora 9i R2 Enterprise).
>>
>> In MSSQL Server 7.0 this tool called SQL Trace and in 2000 called
>> profiler. I need 4 mouse click's and the program runs.
>
>http://www.petefinnigan.com/ramblings/how_to_set_trace.htm
>
>you will need to read the Metalink notes on the trace file format and
>tkprof.

[Quoted] [Quoted] thanks for the link, I know this tool, but I would like to see the sql-cmd's in realtime. In past, I used tkprof on instance level. But it isn't realtime.

Regards Thomas Received on Sat Mar 19 2005 - 20:53:05 CET

Original text of this message