DBMS_KAFKA_LOAD_METRICS
DBMS_KAFKA_LOAD_METRICS displays metrics for DBMS_KAFKA.EXECUTE_LOAD_APP operations on all tables 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 table into which the Kafka data was loaded (TARGET_TABLE) |
CLUSTER_ID |
VARCHAR2(40) |
NOT NULL |
ID of the OSAK cluster associated with the EXECUTE_LOAD_APP operation |
APPLICATION_NAME |
VARCHAR2(30) |
Application name (also used as the Kafka group name) | |
TARGET_TABLE |
VARCHAR2(128) |
NOT NULL |
Name of the table into which the Kafka data was loaded |
TARGET_TABLE_SCHEMA |
VARCHAR2(128) |
NOT NULL |
Schema of the table into which the Kafka data was loaded |
INSERTED_ROWS |
NUMBER(38) |
Total number of rows inserted into the table by the load operation | |
KAFKA_RECORDS |
NUMBER(38) |
Total number of Kafka records fetched for the load operation | |
STARTED_TIME |
TIMESTAMP(6) WITH TIME ZONE |
Date and time at which the Kafka data started being loaded into the table | |
FINISHED_TIME |
TIMESTAMP(6) WITH TIME ZONE |
Date and time at which the Kafka data finished being loaded into the table |
Note: This view is available starting with Oracle AI Database 26ai.
See Also:
-
Oracle AI Database PL/SQL Packages and Types Reference for more information about the
DBMS_KAFKA.EXECUTE_LOAD_APPprocedure