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 AI Database 26ai.
See Also: “USER_KAFKA_MESSAGES”