Answer:

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

Question:

> 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.                [email protected]
> Boulder, CO                     303.381.3020
>
>
>