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