DBA_KAFKA_CLUSTERS

DBA_KAFKA_CLUSTERS describes the Oracle SQL Access to Kafka (OSAK) clusters for which any database user has READ access.

USER_KAFKA_CLUSTERS describes the OSAK clusters that are owned by the current user or for which the current user has READ access. This view does not display the OWNER or GRANTEE columns.

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
KAFKA_PROVIDER VARCHAR2(128) NOT NULL

Provider of the Kafka cluster software:

  • APACHE - Apache Kafka

  • OSS - Oracle Cloud Infrastructure Streaming Service

CONNECTION_TS TIMESTAMP(6)   If GRANTEE is currently connected to the cluster, the date and time at which the connection was started; otherwise NULL
CLUSTER_DESCRIPTION VARCHAR2(4000)   Optional user-supplied description of the Oracle SQL access to the cluster
GRANTEE VARCHAR2(128)   User who is granted access to the cluster

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

See Also: