DBMS_MONITOR.CLIENT_ID_TRACE_DISABLE Procedure

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

Argument Name Type In/Out Default?
CLIENT_ID VARCHAR2 IN DEFAULT

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:

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.