How can one set the tracefile identifier for someone else's session??

  • From: "Andrew Zitelli" <azitelli@xxxxxxxxx>
  • To: oracle-l@xxxxxxxxxxxxx
  • Date: Tue, 15 May 2007 14:55:21 -0700

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

Other related posts: