Re: Monitor Server SQL?

From: Sybrand Bakker <postmaster_at_sybrandb.demon.nl>
Date: Mon, 24 Jan 2000 18:33:26 +0100
Message-ID: <948735321.18022.0.pluto.d4ee154e@news.demon.nl>

look for

v$open_cursor list cursors by session
v$sqlarea lists all sql, including recursive
v$sqltext lists the text only, statements truncated
v$sqltext_with_newlines list the complete statement.

Hth,

--
Sybrand Bakker, Oracle DBA
Michael McKnight <mcknight_at_SignalSoftCorp.com> wrote in message news:388C855F.3C7C9612_at_SignalSoftCorp.com...
> Is there a way or a tool to monitor/capture the incoming SQL from clients?
I
> need to look at some of the SQL generated by some third party libs. Any
> thoughts on this? Thanks.
>
> Mike
>
> --
> Michael McKnight Senior Software Engineer
> SignalSoft Corp. mcknight_at_signalsoftcorp.com
> Boulder, CO 303.381.3020
>
>
>
Received on Mon Jan 24 2000 - 11:33:26 CST