I'd be asking the why and what version question at this point - it's entirely possible that a combination of DBMS_MONITOR and trcsess in 10g will help you.

 

That all said using oradebug to attach to the process gives you the ability to determine (but not set I think) the current tracefile name.

 

 

On 5/15/07, Andrew Zitelli <azitelli@gmail.com> wrote:

Is there an easy way to set a tracefile identifier when tracing someone else's session?  To trace my own session I simply use something like:   alter session set tracefile_identifier='ANDY';

The package DBMS_SYSTEM provides procedures SET_BOOL_PARAM_IN_SESSION and SET_INT_PARAM_IN_SESSION but nothing like SET_VARCHAR_PARAM_IN_SESSION.  I have looked a bit on the web but have not found an answer for this.  Is it possible?

Thanks and kind regards,

Andy Zitelli