Chapter 4: Replication Agent for Oracle
Format of origin queue ID
Each record in the transaction log is identified by an origin
queue ID that consists of 64 hexadecimal characters (32 bytes).
The format of the origin queue ID is determined by the Replication Agent instance,
and it varies according to the primary database type.
Table 4-1 illustrates
the format of the origin queue ID for the Replication Agent for Oracle.
Table 4-1: Replication Agent for Oracle origin
queue ID
Character
|
Bytes
|
Description
|
|---|
0-3
|
2
|
Database generation ID
|
4-19
|
8
|
System change number
|
20-27
|
4
|
Log sequence number
|
28-35
|
4
|
Block number
|
36-39
|
2
|
Block offset, relative to the start of
the block
|
40-47
|
4
|
Oldest active transaction begin log sequence
number
|
48-55
|
4
|
Oldest active transaction begin block
number
|
56-59
|
2
|
Oldest active transaction begin block
offset
|
60-63
|
2
|
Available for specifying uniqueness
|
|
Copyright © 2005. Sybase Inc. All rights reserved.
|
|
View this book as PDF 