About Oracle dbms_monitor

You can use the newly introduced Oracle dbms_monitor package to control additional tracing and statistics gathering. The Oracle dbms_monitor package contains the following procedures used to enable and disable additional statistics aggregation:

Here is an example to enable and disable the tracing based on a client_id:

EXECUTE DBMS_MONITOR.CLIENT_ID_TRACE_ENABLE ('client id');

EXECUTE DBMS_MONITOR.CLIENT_ID_TRACE_DISABLE ('client id');
 

For more dbms_monitor tips see: Advanced Oracle Utilities: The Definitive Reference by Rampant TechPress is written by top Oracle database experts (Bert Scalzo,  Donald Burleson, and Steve Callan).  Buy direct from the publisher and save 30%!