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

SQL> desc dbms_support
FUNCTION MYSID RETURNS NUMBER
FUNCTION PACKAGE_VERSION RETURNS VARCHAR2
PROCEDURE START_TRACE
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
WAITS                          BOOLEAN                 IN     DEFAULT
BINDS                          BOOLEAN                 IN     DEFAULT
PROCEDURE START_TRACE_IN_SESSION
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
SID                            NUMBER                  IN
SERIAL                         NUMBER                  IN
WAITS                          BOOLEAN                 IN     DEFAULT
BINDS                          BOOLEAN                 IN     DEFAULT
PROCEDURE STOP_TRACE
PROCEDURE STOP_TRACE_IN_SESSION
Argument Name                  Type                    In/Out Default?
------------------------------ ----------------------- ------ --------
SID                            NUMBER                  IN
SERIAL                         NUMBER                  IN

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

Other related posts: