SYS_LOGPOS

The SYS_LOGPOS table contains information about the log intervals that the Transaction Log Reader needs for catchup.

Each row represents a log interval which is recorded with the approximate granularity defined with the parameter LogReader.SaveLogposInterval. A new row is added when the size of the current interval is reaching the value of SaveLogposInterval. The sum of the log interval sizes is approximately equal to the value of the parameter LogReader.MaxLogSize. A log interval row is deleted automatically when the distance of the represented log position from the latest recorded log interval head is bigger than LogReader.MaxLogSize.

The SYS_LOGPOS table is only used internally by the Log Reader while executing SYS_LOG table queries; the table does not contain any information to be used when designing applications that use the Log Reader.

If a query requests log records that are beyond the log intervals represented in SYS_LOGPOS, the query returns the error “Log overflow”.

Column name	Data type	Description
ID	INTEGER	Logical log interval ID (identifier of a log interval)
LOG_POS	VARCHAR(255)	Physical position of the head of the log interval
SIZE	INTEGER	Distance in bytes from the previous log interval head position (approximates the value defined with the LogReader.SaveLogposInterval parameter)