How to start trace of an existing session in 10g

How to start trace of an existing session in 10g


10g has a new package called DBMS_MONITOR

EXECUTE DBMS_MONITOR.SESSION_TRACE_ENABLE(&sid,&serial,waits=>true, binds=>false);

To disable
EXECUTE DBMS_MONITOR.SESSION_TRACE_DISABLE(&sid,&serial)

My old article on tracing

http://appstier.blogspot.in/2012/05/activate-extended-sql-trace-for-given.html