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@xxxxxxxxx> 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
-- Niall Litchfield Oracle DBA http://www.orawin.info