7.189 DBMS_KAFKA_OPS_RESULTS

DBMS_KAFKA_OPS displays the results of 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 OSAK view

OP_KEY

VARCHAR2(30)

Unique operation key (replacement for the location file)

ROWS_READ

NUMBER(38)

Number of Kafka records read and returned by the operation

LAST_OFFSET

NUMBER(38)

Kafka offset of the last record read by the operation

OPTIONS

BLOB

Options associated with the operation results

Note:

This view is available starting with Oracle Database 23ai.