142.3 DBMS_OBSERVABILITY Constants

The DBMS_OBSERVABILITY package defines various constants for specifying parameter values.

Table 142-1 DBMS_OBSERVABILITY Constants—Services

Name Type Value Description

ALL_SERVICES

BINARY_INTEGER

0

Represents all services. This is the default value.

Table 142-2 DBMS_OBSERVABILITY Constants—Services Options

Name Type Value Description

ALL_OPTIONS

BINARY_INTEGER

0

Represents all service options.

SHOW_EXTRA_METADATA

BINARY_INTEGER

1

Shows extra metadata. This option is disabled by default.

EXPORT_WHEN_EMPTY

BINARY_INTEGER

2

Enables information even if no records were generated for an operation. This option is disabled by default.

CAPTURE_TRACES

BINARY_INTEGER

3

Captures information that goes to disk by default. This option is enabled by default.

Table 142-3 DBMS_OBSERVABILITY Constants—Info Levels

Name Type Value Description

ALL_INFO

BINARY_INTEGER

0

Shows all information levels.

RUNTIME_INFO

BINARY_INTEGER

1

Shows the CDB configuration so that the client can determine if a service or option is available for use.

CONTAINER_INFO

BINARY_INTEGER

2

Shows the current container's information.

Table 142-4 DBMS_OBSERVABILITY Constants—Token Types

Name Type Value Description

OCI_DATAKEY

BINARY_INTEGER

0

Represents a token of the type DATAKEY.

Table 142-5 DBMS_OBSERVABILITY Constants—Endpoint Types

Name Type Value Description

OTEL_LOGS

BINARY_INTEGER

0

Specifies that the endpoint type can ingest OTLP (OpenTelemetry Protocol) logs.*

OTEL_TRACES

BINARY_INTEGER

1

Specifies that the endpoint type can ingest OTLP (OpenTelemetry Protocol) traces.*

*Only HTTP2 is supported.