RSS Feed

Method R Discussion Group

How can you trace other people's session and how can we set trace file identifier for those sessions in 10g?

Do this in sqlplus on your 10g system:

SQL> describe dbms_monitor

This will show you several procedures you can use to alter the tracing status of sessions on the system. There is excellent documentation about DBMS_MONITOR in the standard Oracle Database 10g documentation set as well. In this documentation, you can see how to manipulate other sessions that you can identify either by sid and serial#, or by service name, module name, action name, or client id.

To the best of my knowledge, you cannot change a non-you session's trace file identifier. You can set other sessions' boolean and numerical values with dbms_system. But to the best of my knowledge, there is no dbms_system.set_xxx_in_session for string values.