7.593 USER_KAFKA_MESSAGES

USER_KAFKA_MESSAGES displays messages logged by Oracle SQL Access to Kafka (OSAK) applications owned by the current user.

Column	Datatype	NULL	Description
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
MESSAGE_TYPE	VARCHAR2(20)		Message type. Possible values: BADFILE LOGFILE NETWORK ROLLBACK
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.

See Also:

"DBMS_KAFKA_MESSAGES"