Re: How Do I see what SQL is being RUN

v$session has the address of the current sql_statement. You could join v$session and v$sqltext_with_newline to get the CURRENT statement. You could also query v$open_cursor to find out all the statements being executed by a session.
You could also enable trace for that session only with dbms_system.set_sql_trace_in_session(sid, serial) [parameters are in v$session]
Numerous ways to do it...

Hth,

--
Sybrand Bakker, Oracle DBA
Scot Needy <sneedy_at_infi.net> wrote in message news:85kv94$v3d$1_at_nw001t.infi.net...
> Hi;
>
> This is probably asked 100 times but...
>
> How would I seee what sql a product is running against my database?
>
> I have the username and they are connecting from a remote machine using
> TCP. Do you have to turn on trace in the liteners or can you select
> from a v$ ?
>
> Thanks
> Scot
Received on Thu Jan 13 2000 - 12:20:25 CST