Enhancement Request : enabling extendend 10046 trace in session

[orca777]

Hi,
Fur better response time analyses the enabling of the extended trace event 10046 in sessions should be possible.

The functionality is included in dbms_support package which is not included in the standard installation. Oracle recommends that the package should only installed by oracle support:
But this not obvious. it's just a package and 10046 events could be enabled via ALTER SESSION ... too.

Here the package Interface:

SQL> desc dbms_support
Element                Type
---------------------- ---------
PACKAGE_VERSION        FUNCTION
MYSID                  FUNCTION
START_TRACE            PROCEDURE
STOP_TRACE             PROCEDURE
START_TRACE_IN_SESSION PROCEDURE
STOP_TRACE_IN_SESSION  PROCEDURE

SQL> desc dbms_support.start_trace_in_session
Parameter Type    Mode Default?
--------- ------- ---- --------
SID       NUMBER  IN
SERIAL    NUMBER  IN
WAITS     BOOLEAN IN   Y
BINDS     BOOLEAN IN   Y

SQL> desc dbms_support.stop_trace_in_session
Parameter Type   Mode Default?
--------- ------ ---- --------
SID       NUMBER IN
SERIAL    NUMBER IN

SQL>

If the dbms_support package exists and is executable for the current user is should be used in session window tool.

With kind regards
Carl

 

[Marco Kalter]

I have added this to the list of enhancement requests.