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 AI Database 26ai.

See Also: