7.604 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"