Title: RE: Tracing a user session with multiple database connections
It may need some changes for the Alter Session syntax but the trigger should help you isolate the activity by these session.
HTH
Tony Aponte
CREATE OR REPLACE TRIGGER sys.trap_conversion_connect_trig
AFTER LOGON
Schauss, Peter wrote:
Is there any way to trace all of the connections
for a given sid without setting sql_trace for the entire instance?
You could try creating a trigger to do it. create trigger foo after
login on database ...
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--