Re: Realtime SQL Trace like MS SQL Server
From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Sat, 19 Mar 2005 18:22:47 -0000
Message-ID: <423c6dae$0$10946$cc9e4d1f_at_news-text.dial.pipex.com>
Date: Sat, 19 Mar 2005 18:22:47 -0000
Message-ID: <423c6dae$0$10946$cc9e4d1f_at_news-text.dial.pipex.com>
[Quoted] "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.
-- Niall Litchfield Oracle DBA http://www.niall.litchfield.dial.pipex.comReceived on Sat Mar 19 2005 - 19:22:47 CET