142.4.11 ENABLE_SERVICE_OPTION Procedure

The ENABLE_SERVICE_OPTION procedure enables the specified services options.

Syntax

DBMS_OBSERVABILITY.ENABLE_SERVICE_OPTION( option_id IN BINARY_INTEGER DEFAULT all_options );

Parameters

Table 142-17 ENABLE_SERVICE Procedure Parameters

Parameter Description

option_id

Specifies the service option or options to enable.

Usage Notes

The CDB is a global reference for service availability, that is, the PDBs will only be able to use a service enabled both on the current container and at the CDB.

Examples

The following example illustrates how to enable capturing traces:
SQL> execute dbms_observability.enable_service_option( option_id => dbms_observability.capture_traces );
The following example illustrates how to enable all options using the default option:
SQL> execute dbms_observability.enable_service_option;