You can run this SQL as a DBA User. This query lists the SQL statements
for all ACTIVE/INACTIVE users. You can then filter out the SQL statements
based on SCHEMA or other information.
-----------------------------------------------------------------
SELECT S.SID, S.USERNAME, S.MACHINE, S.TERMINAL, S.SCHEMANAME,
S.PROGRAM, S.TYPE, S.STATUS, T.PIECE, T.SQL_TEXT
FROM V$SESSION S, V$SQLTEXT T
WHERE S.SQL_ADDRESS = T.ADDRESS
AND S.USERNAME IS NOT NULL
ORDER BY S.SID, S.USERNAME, T.PIECE
-----------------------------------------------------------------
You can also use TOAD or even DBASTUDIO to peek at the SQL statments.
Cheers,
Rath
"Ross Luker" <ro********@hotmail.com> wrote in message
news:45**************************@posting.google.c om...
Hi,
Being a newbie to Oracle generally, is there a tool that will
stream/log the SQL statements being issued by my application to the
database?
TIA
Ross