Trace session

If I run the appication and I want to trace what's running from that session, how can I do that ???

I can't use ALTER SESSION SET SQL_TRACE =TRUE b/c I run from the application. I really need to find out what running from the application

Thanks

get the sid and serial# from v$session and run this query

Code:

---

select sql_text from v$sqltext_with_newlines
where (hash_value,address) in(
select sql_hash_value,sql_address from v$session
where sid=&sid and serial#=&Serial)
order by address,piece

---

Sanjay

execute dbms_system.set_sql_trace_in_session(sid, serial, TRUE);

where sid and serial no. will be from v$session.

run it with FALSE to stop tracing for that session.