DBMS_KAFKA_CLUSTERS

7.185 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 Database 23ai.