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 AI Database 26ai.

See Also: “DBMS_KAFKA_MESSAGES”