DBMS_KAFKA_APPLICATIONS

7.184 DBMS_KAFKA_APPLICATIONS

DBMS_KAFKA_APPLICATIONS describes all Oracle SQL Access to Kafka (OSAK) applications 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 application
`CLUSTER_ID`	`VARCHAR2(40)`	`NOT NULL`	ID of the OSAK cluster associated with the application
`APPLICATION_NAME`	`VARCHAR2(30)`	`NOT NULL`	Application name (also used as the Kafka group name)
`TOPIC_NAME`	`VARCHAR2(249)`	`NOT NULL`	Name of the Kafka topic associated with the application
`NUM_VIEWS`	`NUMBER(38)`	`NOT NULL`	Number of OSAK views for the application
`NUM_PARTITIONS`	`NUMBER(38)`	`NOT NULL`	Number of Kafka partitions associated with the OSAK views for the application
`NUM_VIEWS_REQUESTED`	`NUMBER(38)`	`NOT NULL`	Number of OSAK views requested for the application
`APPLICATION_TYPE`	`VARCHAR2(30)`	`NOT NULL`	Type of application: `LOAD` `SEEKABLE` `STREAMING`
`OPTIONS`	`BLOB`	`NOT NULL`	User-supplied options (excluding AVRO-related schemas)
`AVRO_SCHEMA`	`BLOB`		User-supplied AVRO schema for the Kafka topic value data
`KEY_AVRO_SCHEMA`	`BLOB`		Reserved for future use
`EXT_TABLE_NAME`	`VARCHAR2(128)`		Name of the external table created for the application
`EXT_TABLE_SCHEMA`	`VARCHAR2(128)`		Schema of the external table created for the application
`PARTITION_TABLE_NAME`	`VARCHAR2(128)`		Name of the `PARTITIONS` table created for the application
`PARTITION_TABLE_SCHEMA`	`VARCHAR2(128)`		Schema of the `PARTITIONS` table created for the application
`PARTITION_VIEW_NAME`	`VARCHAR2(128)`		Name of the `PARTITIONS` view created for the application
`PARTITION_VIEW_SCHEMA`	`VARCHAR2(128)`		Schema of the `PARTITIONS` view created for the application

Note:

This view is available starting with Oracle Database 23ai.