6.161 DBA_KAFKA_CLUSTERS

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

Related View

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

See Also: