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

 Argument Name                  Type                    In/Out Default?
 ------------------------------ ----------------------- ------ --------
 SID                            NUMBER                  IN
 SERIAL                         NUMBER                  IN

On 5/15/07, Andrew Zitelli <azitelli_at_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
>

--
http://www.freelists.org/webpage/oracle-l