Re: Realtime SQL Trace like MS SQL Server

From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 19 Mar 2005 12:05:39 -0800
Message-ID: <1111262543.175827_at_yasure>


Thomas Hase wrote:

> On Sat, 19 Mar 2005 18:22:47 -0000, "Niall Litchfield"
> <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.

>
>
>
> 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

Real time there are a number of ways. One of the best is with OEM.

-- 
Daniel A. Morgan
University of Washington
damorgan_at_x.washington.edu
(replace 'x' with 'u' to respond)
Received on Sat Mar 19 2005 - 21:05:39 CET

Original text of this message