Re: How to trace a session in MTS (8iR3)

> Taking a session-to-processes look, I noticed that the same session (SID)
> has different SPID in v$processes during its lifecycle. So, when people c=
all
> me saying that a reporting is longing more than 10 times the usual time, =
how
> do I trace that specific session in MTS?
Sid,Serial# of the session will be permanent in MTS case. You just need to enable extended SQL trace for long running session (assuming that you are on 8i you can use either dbms_system.set_ev or dbms_support.start_trace_in_session). But in MTS case, trace data will probably be saved in several trace files. So you just need one additional step to extract your data and put them in one file.

If you have an access to Oracle 10g you can use, as suggested Mladen, trcsess utility from $ORACLE_HOME/bin. Otherwise you can use my utility trcsess.py which I distribute with my profiler (link in signature).

--=20
Egor
http://www.oracledba.ru/orasrp/
Free Oracle Session Resource Profiler

--
http://www.freelists.org/webpage/oracle-l