| Oracle® TimesTen In-Memory Database SQL Reference Release 11.2.1 Part Number E13070-04 |
|
|
View PDF |
| Oracle® TimesTen In-Memory Database SQL Reference Release 11.2.1 Part Number E13070-04 |
|
|
View PDF |
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 |
|
 Copyright © 1996, 2009, Oracle and/or its affiliates. All rights reserved. Legal Notices |
|
