Oracle Internals
JulianDyke.com

Welcome

Seminars

Consultancy

Calendar

Presentations

Diagnostics

Internals

References

Acknowledgements

Packages

PROCEDURE DBMS_MONITOR.CLIENT_ID_STAT_DISABLE

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