DBA_KAFKA_LOAD

6.162 DBA_KAFKA_LOAD_METRICS

DBA_KAFKA_LOAD_METRICS displays metrics for DBMS_KAFKA.EXECUTE_LOAD_APP operations on all tables in the database.

Related View

USER_KAFKA_LOAD_METRICS displays metrics for DBMS_KAFKA.EXECUTE_LOAD_APP operations on tables owned by the current user. This view does not display the OWNER or CLUSTER_ID columns.

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
`CLUSTER_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the OSAK cluster associated with the OSAK cluster ID
`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.