Re: Realtime SQL Trace like MS SQL Server
From: DA Morgan <damorgan_at_x.washington.edu>
Date: Sat, 19 Mar 2005 14:26:53 -0800
Message-ID: <1111271017.896508_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.
Date: Sat, 19 Mar 2005 14:26:53 -0800
Message-ID: <1111271017.896508_at_yasure>
Thomas Hase wrote:
> 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?
Not from where I am right now, teaching a RAC class, but hopefully someone else can provide you with navigation that looks at v_$session_longops.
-- [Quoted] Daniel A. Morgan University of Washington damorgan_at_x.washington.edu (replace 'x' with 'u' to respond)Received on Sat Mar 19 2005 - 23:26:53 CET