DBMS_MONITOR.CLIENT_ID_STAT_DISABLE Procedure

This procedure, which was introduced in Oracle 10.1, disables statistics collection for all sessions with the specified client ID.

Argument Name Type In/Out Default?
CLIENT_ID VARCHAR2 IN  

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

For example to disable statistics collection trace for CLIENT_ID 'ID1' use:

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