Packages

PROCEDURE DBMS_MONITOR.CLIENT_ID_TRACE_DISABLE

This procedure, which was introduced in Oracle 10.1, disables event 10046 trace for all sessions with the specified client ID.

The CLIENT_ID must be specified, but does not belong to a current session at the time this procedure is invoked.

For example to disable event 10046 trace for CLIENT_ID 'ID1' use: use

    EXECUTE dbms_monitor.client_id_trace_disable (client_id=>'ID1');

The current state of client_id trace is reported in the data dictionary view DBA_ENABLED_TRACES.