Re: help: How do you set event 10046 in this situation

On Fri, 24 Dec 2004 07:32:49 -0800, fitzjarrell wrote:

> If someone knows of a method of setting event 10046 for an unknown
> session or fleeting sessions without knowing the SID or SERIAL# that
> is, I believe, what the OP is looking for.

DBMS_MONITOR.CLIENT_ID_TRACE_ENABLE(
   client_id IN VARCHAR2,

   waits        IN  BOOLEAN DEFAULT TRUE,
   binds        IN  BOOLEAN DEFAULT FALSE);

Client ID is an identifier set by using
DBMS_APPLICATION_INFO.SET_CLIENT_INFO.
DBMS_MONITOR package looks like this:

SQL> desc dbms_monitor
PROCEDURE CLIENT_ID_STAT_DISABLE

 Argument Name                  Type                    In/Out Default?


 ------------------------------ ----------------------- ------ --------

 CLIENT_ID                      VARCHAR2                IN
PROCEDURE CLIENT_ID_STAT_ENABLE
 Argument Name                  Type                    In/Out Default?


 ------------------------------ ----------------------- ------ --------

 CLIENT_ID                      VARCHAR2                IN
PROCEDURE CLIENT_ID_TRACE_DISABLE
 Argument Name                  Type                    In/Out Default?


 ------------------------------ ----------------------- ------ --------

 CLIENT_ID                      VARCHAR2                IN
PROCEDURE CLIENT_ID_TRACE_ENABLE
 Argument Name                  Type                    In/Out Default?


 ------------------------------ ----------------------- ------ --------

 CLIENT_ID                      VARCHAR2                IN
 WAITS                          BOOLEAN                 IN     DEFAULT
 BINDS                          BOOLEAN                 IN     DEFAULT
PROCEDURE SERV_MOD_ACT_STAT_DISABLE
 Argument Name                  Type                    In/Out Default?


 ------------------------------ ----------------------- ------ --------

 SERVICE_NAME                   VARCHAR2                IN
 MODULE_NAME                    VARCHAR2                IN
 ACTION_NAME                    VARCHAR2                IN     DEFAULT
PROCEDURE SERV_MOD_ACT_STAT_ENABLE
 Argument Name                  Type                    In/Out Default?


 ------------------------------ ----------------------- ------ --------

 SERVICE_NAME                   VARCHAR2                IN
 MODULE_NAME                    VARCHAR2                IN
 ACTION_NAME                    VARCHAR2                IN     DEFAULT
PROCEDURE SERV_MOD_ACT_TRACE_DISABLE
 Argument Name                  Type                    In/Out Default?


 ------------------------------ ----------------------- ------ --------

 SERVICE_NAME                   VARCHAR2                IN
 MODULE_NAME                    VARCHAR2                IN     DEFAULT
 ACTION_NAME                    VARCHAR2                IN     DEFAULT
 INSTANCE_NAME                  VARCHAR2                IN     DEFAULT
PROCEDURE SERV_MOD_ACT_TRACE_ENABLE
 Argument Name                  Type                    In/Out Default?


 ------------------------------ ----------------------- ------ --------

 SERVICE_NAME                   VARCHAR2                IN
 MODULE_NAME                    VARCHAR2                IN     DEFAULT
 ACTION_NAME                    VARCHAR2                IN     DEFAULT
 WAITS                          BOOLEAN                 IN     DEFAULT
 BINDS                          BOOLEAN                 IN     DEFAULT
 INSTANCE_NAME                  VARCHAR2                IN     DEFAULT
PROCEDURE SESSION_TRACE_DISABLE
 Argument Name                  Type                    In/Out Default?


 ------------------------------ ----------------------- ------ --------

 SESSION_ID                     BINARY_INTEGER          IN     DEFAULT
 SERIAL_NUM                     BINARY_INTEGER          IN     DEFAULT
PROCEDURE SESSION_TRACE_ENABLE
 Argument Name                  Type                    In/Out Default?


 ------------------------------ ----------------------- ------ --------

 SESSION_ID                     BINARY_INTEGER          IN     DEFAULT
 SERIAL_NUM                     BINARY_INTEGER          IN     DEFAULT
 WAITS                          BOOLEAN                 IN     DEFAULT
 BINDS                          BOOLEAN                 IN     DEFAULT

SQL>

-- 
Artificial Intelligence is no match for natural stupidity.