7.186 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 Database 23ai.

See Also:

• "DBA_KAFKA_LOAD_METRICS"

• "USER_KAFKA_LOAD_METRICS"

• Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_KAFKA.EXECUTE_LOAD_APP procedure