Skip Headers
Oracle® TimesTen In-Memory Database SQL Reference
Release 11.2.1

Part Number E13070-03
Go to Documentation Home
Home
Go to Book List
Book List
Go to Table of Contents
Contents
Go to Index
Index
Go to Master Index
Master Index
Go to Feedback page
Contact Us

Go to previous page
Previous
Go to next page
Next
View PDF

SYS.TRANSACTION_LOG_API

The TRANSACTION_LOG_API table keeps track of the persistent Transaction Log API bookmarks. Each row in the system table corresponds to a persistent bookmark. Each persistent bookmark has a text identifier associated with it, which is used to keep track of the bookmark.

These columns are for internal use: REPLICATED, ID_A, ID_B, CTN_HIGH_A, CTN_HIGH_B, CTN_LOW_A, CTN_LOW_B.

Columns

Column name Type Description
ID TT_CHAR (31) NOT NULL A text tag identifier used to keep track of the bookmark.
READLSNHIGH TT_INTEGER NOT NULL The high value of the read log record to which this bookmark points.
READLSNLOW TT_INTEGER NOT NULL The low value of the read log record to which this bookmark points.
PURGELSNHIGH TT_INTEGER NOT NULL The high value of the lowest LSN required by this bookmark.
PURGELSNLOW TT_INTEGER NOT NULL The low value of the lowest LSN required by this bookmark.
PID TT_INTEGER NOT NULL The process ID of the process to last open the XLA bookmark.
INUSE BINARY (1) NOT NULL Bookmark being used by any persistent Transaction Log API connection.
REPLICATED BINARY(1) Used for a replicated bookmark
COUNTER TT_BIGINT Used for a replicated bookmark
COUNTER_A TT_BIGINT Used for a replicated bookmark
COUNTER_B TT_BIGINT Used for a replicated bookmark
CTN_HIGH_A TT_INTEGER Used for a replicated bookmark
CTN_LOW_A TT_INTEGER Used for a replicated bookmark
CTN_HIGH_B TT_INTEGER Used for a replicated bookmark
CTN_LOW_B TT_INTEGER Used for a replicated bookmark