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:
| Argument Name | Type | In/Out | Default? |
| INSTANCE_NAME | VARCHAR2 | IN | DEFAULT |
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';For example to disable event 10046 trace for all sessions in instance RAC1 use:
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';