DBA_KAFKA_PARTITIONS

6.165 DBA_KAFKA_PARTITIONS

DBA_KAFKA_PARTITIONS describes partitions for Kafka topics associated with all Oracle SQL Access to Kafka (OSAK) views in the database.

Related View

USER_KAFKA_PARTITIONS describes partitions for Kafka topics associated with OSAK views owned by the current user. This view does not display the OWNER or CLUSTER_ID columns.

Column	Datatype	NULL	Description
`OWNER`	`VARCHAR2(128)`	`NOT NULL`	Owner of the OSAK view
`CLUSTER_ID`	`VARCHAR2(40)`	`NOT NULL`	ID of the OSAK cluster associated with the topic/partition
`CLUSTER_NAME`	`VARCHAR2(30)`	`NOT NULL`	User-supplied name of the associated Kafka server/cluster
`APPLICATION_NAME`	`VARCHAR2(30)`	`NOT NULL`	Application name (also used as the Kafka group name)
`TOPIC_NAME`	`VARCHAR2(249)`	`NOT NULL`	Kafka topic name associated with the topic/partition
`PARTITION_ID`	`NUMBER(38)`	`NOT NULL`	Partition ID of the Kafka topic
`VIEW_ID`	`NUMBER(38)`	`NOT NULL`	ID of the OSAK view associated with the topic/partition
`VIEW_NAME`	`VARCHAR2(128)`	`NOT NULL`	Name of the OSAK view associated with the topic/partition
`TEMP_TABLE_NAME`	`VARCHAR2(128)`		Name of the OSAK global temporary table associated with the topic/partition The value of this column is null if the application type is `LOAD`, that is, if the application was created using the `DBMS_KAFKA.CREATE_LOAD_APP` procedure. The application type is displayed in the `APPLICATION_TYPE` column of the `DBA_KAFKA_APPLICATIONS` view.

Note:

This view is available starting with Oracle Database 23ai.