Packages

PROCEDURE DBMS_MONITOR.DATABASE_TRACE_DISABLE

This procedure, which was introduced in Oracle 10.1, disables event 10046 trace for the entire database or in a RAC environment for the specified instance.

This procedure takes the following arguments:

There is one optional parameter, INSTANCE_NAME, which defaults to NULL.

If the INSTANCE_NAME is NULL then trace is disabled for all sessions in the database

If the INSTANCE_NAME is NOT NULL then trace is disabled for all sessions in the specified instance.

This functionality was not previously available in a clustered database environment.

For example to disable event 10046 trace for all sessions in the database use:

    EXECUTE dbms_monitor.database_trace_disable

In a single-instance database this is similar to:

    ALTER SYSTEM SET EVENTS
    '10046 trace name context off';

    EXECUTE dbms_monitor.database_trace_disable (instance_name=>'RAC1');

In the current instance this is equivalent to:

    ALTER SYSTEM SET EVENTS
    '10046 trace name context off';