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');