DBMS_KAFKA_MESSAGES

7.187 DBMS_KAFKA_MESSAGES

DBMS_KAFKA_MESSAGES displays messages logged by 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
`CLUSTER_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the OSAK cluster associated with the application
`APPLICATION_NAME`	`VARCHAR2(30)`		Application name (also used as the Kafka group name)
`VIEW_NAME`	`VARCHAR2(128)`		Name of the view associated with the application
`VIEW_SCHEMA`	`VARCHAR2(128)`		Schema of the view associated with the application
`MESSAGE_TYPE`	`VARCHAR2(20)`		Message type
`MESSAGE_TS`	`TIMESTAMP(6)`		Timestamp for when the message was logged
`MESSAGE`	`VARCHAR2(4000)`		Message text

Note:

This view is available starting with Oracle Database 23ai.