DBA_KAFKA_CLUSTERS

6.160 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.