Striim 3.9.6 documentation

OracleReader WAEvent fields

The output data type for OracleReader is WAEvent.

metadata: for DML operations, the most commonly used elements are:

  • OperationName: COMMIT, BEGIN, INSERT, DELETE, UPDATE, or (when using LogMiner only) ROLLBACK

  • TxnID: transaction ID

  • TimeStamp: timestamp from the CDC log

  • TableName (returned only for INSERT, DELETE, and UPDATE operations): fully qualified name of the table

  • ROWID (returned only for INSERT, DELETE, and UPDATE operations): the Oracle ID for the inserted, deleted, or updated row

To retrieve the values for these elements, use the META function. See Parsing the fields of WAEvent for CDC readers.

data: for DML operations, an array of fields, numbered from 0, containing:

  • for an INSERT or DELETE operation, the values that were inserted or deleted

  • for an UPDATE, the values after the operation was completed

To retrieve the values for these fields, use SELECT ... (DATA[]). See Parsing the fields of WAEvent for CDC readers.

before (for UPDATE operations only): the same format as data, but containing the values as they were prior to the UPDATE operation

dataPresenceBitMap, beforePresenceBitMap, and typeUUID are reserved and should be ignored.

The following is a complete list of fields that may appear in metadata. The actual fields will vary depending on the operation type and other factors.

metadata property

present when using LogMiner

present when using XStream Out

comments

AuditSessionID

x

Audit session ID associated with the user session making the change

BytesProcessed

x

CatalogObjectName

x

see OracleReader WAEvent fields for DDL operations

CatalogObjectType

x

see OracleReader WAEvent fields for DDL operations

ColumnIsKey

x

see OracleReader WAEvent fields for DDL operations

ColumnLength

x

see OracleReader WAEvent fields for DDL operations

ColumnIsNullable

x

see OracleReader WAEvent fields for DDL operations

ColumnMetadata

x

see OracleReader WAEvent fields for DDL operations

ColumnName

x

see OracleReader WAEvent fields for DDL operations

ColumnPrecision

x

see OracleReader WAEvent fields for DDL operations

COMMIT_TIMESTAMP

x

x

the UNIX epoch time the transaction was committed, based on the Striim server's time zone

COMMITSCN

x

x

system change number (SCN) when the transaction committed

DBCommitTimestamp

x

the UNIX epoch time the transaction was committed, based on the Oracle server's time zone

DBTimestamp

x

the UNIX epoch time of the operation, based on the Oracle server's time zone

ObjectName

x

see OracleReader WAEvent fields for DDL operations

ObjectType

x

see OracleReader WAEvent fields for DDL operations

OperationName

x

x

user-level SQL operation that made the change (INSERT, UPDATE, ...)

OperationSubType

x

see OracleReader WAEvent fields for DDL operations

OperationType

x

x

the Oracle operation type (COMMIT, DDL, DELETE, INSERT, INTERNAL, LOB_ERASE, LOB_TRIM, LOB_WRITE, MISSING_SCN, ROLLBACK, SELECT_FOR_UPDATE, SELECT_LOB_LOCATOR, START, UNSUPPORTED, or UPDATE)

OwnerName

x

see OracleReader WAEvent fields for DDL operations

ParentTxnID

x

raw representation of the parent transaction identifier

PK_UPDATE

x

true if an UPDATE operation changed the primary key, otherwise false

RbaBlk

x

RBA block number within the log file

RbaSqn

x

sequence# associated with the Redo Block Address (RBA) of the redo record associated with the change

RecordSetID

x

Uniquely identifies the redo record that generated the row. The tuple (RS_ID, SSN) together uniquely identifies a logical row change.

RollBack

x

1 if the record was generated because of a partial or a full rollback of the associated transaction, otherwise 0

ROWID

x

x

Row ID of the row modified by the change (only meaningful if the change pertains to a DML). This will be NULL if the redo record is not associated with a DML.

SCN

x

x

system change number (SCN) when the database change was made

SegmentName

x

name of the modified data segment

SegmentType

x

type of the modified data segment (INDEX, TABLE, ...)

Serial

x

serial number of the session that made the change

Session

x

session number of the session that made the change

SessionInfo

x

Information about the database session that executed the transaction. Contains process information, machine name from which the user logged in, client info, and so on.

SQLRedoLength

x

length of reconstructed SQL statement that is equivalent to the original SQL statement that made the change

TableMetadata

x

see OracleReader WAEvent fields for DDL operations

TableName

x

x

name of the modified table (in case the redo pertains to a table modification)

TableSpace

x

name of the tablespace containing the modified data segment.

ThreadID

x

ID of the thread that made the change to the database

TimeStamp

x

x

the UNIX epoch time of the operation, based on the Striim server's time zone

TransactionName

x

x

name of the transaction that made the change (only meaningful if the transaction is a named transaction)

TxnID

x

x

raw representation of the transaction identifier

TxnUserID

x

x