Re: How can one set the tracefile identifier for someone else's session??
- From: "sol beach" <sol.beach@xxxxxxxxx>
- To: azitelli@xxxxxxxxx
- Date: Tue, 15 May 2007 17:09:49 -0700
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:
