DBMS_KAFKA_CLUSTERS

DBMS_KAFKA_CLUSTERS describes all registered Oracle SQL Access to Kafka (OSAK) clusters in the database.

The role OSAK_ADMIN_ROLE allows users with no administrative privileges to query this table.

Column Datatype NULL Description
OWNER VARCHAR2(128) NOT NULL

Owner of the cluster

The value of this column is always SYS.

CLUSTER_ID VARCHAR2(40) NOT NULL System-generated unique cluster ID
STATE NUMBER(38) NOT NULL

Current state of the cluster:

  • 0 - CONNECTED

  • 1 - MAINTENANCE

  • 2 - BROKEN

  • 3 - DEREGISTERED

CLUSTER_NAME VARCHAR2(30) NOT NULL User-supplied name of the cluster
BOOTSTRAP_SERVERS VARCHAR2(4000) NOT NULL

Comma-separated list of bootstrap servers for the cluster

Each bootstrap server is represented in the following form: hostname:port
CLUSTER_ACCESS_DIRECTORY VARCHAR2(128) NOT NULL

Name of the directory object associated with the cluster

Users with READ access to this directory object are allowed to access the cluster.

KAFKA_PROVIDER VARCHAR2(128) NOT NULL

Provider of the Kafka cluster software:

  • APACHE - Apache Kafka

  • OSS - Oracle Cloud Infrastructure Streaming Service

CREDENTIAL_NAME VARCHAR2(128)   If KAFKA_PROVIDER = OSS, the name of the database credential for the Oracle Cloud Infrastructure Streaming Service connection
CREDENTIAL_SCHEMA VARCHAR2(128)   If KAFKA_PROVIDER = OSS, the schema of CREDENTIAL_NAME
CLUSTER_CONFIG_DIRECTORY VARCHAR2(128)   If KAFKA_PROVIDER = APACHE, the directory object that references the operating system directory containing the osakafka.properties file for the cluster
CLUSTER_DESCRIPTION VARCHAR2(4000)   Optional user-supplied description of the Oracle SQL access to the cluster
CONNECTION_TS TIMESTAMP(6)  

Timestamp of the last known successful connection to the cluster

The value of this column is NULL if a disconnect occurred or if there has never been a connection to the cluster.
OPTIONS BLOB   Optional user-supplied options for the cluster

Note: This view is available starting with Oracle AI Database 26ai.

See Also: