Re: Realtime SQL Trace like MS SQL Server

On Sat, 19 Mar 2005 12:05:39 -0800, DA Morgan <damorgan_at_x.washington.edu> wrote:

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

Please, can you specify, wich button in OEM (Perfmon?) did you mean? Received on Sat Mar 19 2005 - 23:12:38 CET