DBA_KAFKA

6.163 DBA_KAFKA_OPS

DBA_KAFKA_OPS describes operations for all Oracle SQL Access to Kafka (OSAK) views in the database.

Related View

USER_KAFKA_OPS describes operations for OSAK views 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 OSAK view
`OP_KEY`	`VARCHAR2(30)`	`NOT NULL`	Unique operation key (replacement for the location file)
`OP_TYPE`	`VARCHAR2(30)`	`NOT NULL`	Generic operation type
`OP`	`VARCHAR2(30)`	`NOT NULL`	Specific type of operation within `OP_TYPE`
`CLUSTER_ID`	`VARCHAR2(40)`	`NOT NULL`	ID of the OSAK cluster associated with the operation
`CLUSTER_NAME`	`VARCHAR2(30)`	`NOT NULL`	Name of the OSAK cluster associated with the operation
`APPLICATION_NAME`	`VARCHAR2(30)`		Name of the OSAK application associated with the operation (also used as the Kafka group name)
`TOPIC_NAME`	`VARCHAR2(249)`		Name of the Kafka topic associated with the operation
`PARTITION_ID`	`NUMBER(38)`		Partition ID of the Kafka topic associated with the operation
`OFFSET`	`NUMBER(38)`		Next offset from which an SEQ operation will start reading
`RELATIVE_OFFSET`	`NUMBER(38)`		Number of offsets, including the watermark, from which an SEQ operation will start reading
`WATERMARK`	`VARCHAR2(5)`		Basis for the start read offset for an SEQ operation (`WMH` or `WML`)
`START_OFFSET_EPOCH_TIME`	`NUMBER(38)`		Timestamp (in milliseconds) that determines the next offset from which the operation will start reading This value is used by the `DBMS_KAFKA.INIT_OFFSET_TS` and `DBMS_KAFKA.SEEK_OFFSET_TS` procedures.
`END_OFFSET_EPOCH_TIME`	`NUMBER(38)`		Timestamp (in milliseconds) that determines the end offset at which the operation will stop reading This value is used by the `DBMS_KAFKA.SEEK_OFFSET_TS` procedure.

Note:

This view is available starting with Oracle Database 23ai.