7.188 DBMS_KAFKA_OPS

DBMS_KAFKA_OPS describes operations for all Oracle SQL Access to Kafka (OSAK) views 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 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
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.
OPTIONS	BLOB		Options associated with the operation

Note:

This view is available starting with Oracle Database 23ai.

See Also:

• "DBA_KAFKA_OPS"

• "USER_KAFKA_OPS"

• Oracle Database PL/SQL Packages and Types Reference for more information about the DBMS_KAFKA.INIT_OFFSET_TS and DBMS_KAFKA.SEEK_OFFSET_TS procedures