Timesten - Transaction Log

Timesten Component

About

Changes to databases are captured in transaction logs that are written to disk periodically.

Log records are generated with the execution of INSERT, UPDATE and DELETE operations.

Normal disk file systems are used for transaction log files.

Buffer

Server DSN Connection attribute in order to set the properties of the Log Buffer.

LogFileSize=1024 
LogBufMB=1024 
LogBufParallelism=16 

The TimesTen transaction log buffer size has a default size of 64 Mb.

If your application is write intensive, creating a bigger memory log buffer reduces log contention and avoids log buffer waits.

You can monitor the LOG_BUFFER_WAIT value for I/O contention and increase its size if needed:

select LOG_BUFFER_WAIT from sys.MONITOR;





Discover More
Timesten Cache Group Attribute
TimesTen - Cache Group

A cache group is a collection of one or more cached Oracle tables: related to each other by foreign key constraints. arranged in a logical hierarchy by using primary key and foreign key relationships....
Timesten Component
Timesten - (Diagnostic Information|daemon log)

The daemon generates the diagnostic information also known as: TimesTen system messages daemon log such as: error, warning, informational and debug messages At installation time, you...
Timesten Component
Timesten - (Large|Huge) Pages Configuration

If a TimesTen database larger than 256GB is required, then you must configure Timesten in order to use large pages. Depending upon the Operating System you are using, you should look into enabling large...
Timesten Component
Timesten - (Memory|Database) (Size|Space|Partition)

TimesTen manages database space using two separate memory partitions within a single contiguous memory space. One partition contains: permanent data and the other contains temporary data. ...
Timesten Component
Timesten - Checkpoint

TimesTen databases are automatically persisted to disk storage using periodic checkpoints to keep snapshots of the database. Checkpoint files contain an image of the database on disk. TimesTen uses...
Timesten Component
Timesten - Commit

TimesTen supports two kinds of commit: Type Default Connection att DurableCommits Avantage Disavantage Delayed durability Yes 0 High performance Small possibility of data loss Immediate durability...
Timesten Component
Timesten - Database

A TimesTen database is a collection of elements such as: tables, views, and sequences that can be accessed and manipulated through SQL. Each TimesTen database is created when the first connection...
Timesten Component
Timesten - Database Installation and configuration on Linux

On UNIX/Linux systems before installing application, you must in general configure the following: The number of semaphores Allowable shared memory In addition for timesten, you need to perform the...
Timesten Component
Timesten - Recover

If a database needs to be recovered, TimesTen merges the database checkpoint on disk with the completed transactions that are still in the transaction log files. Recovery is never performed for temporary...
Timesten Component
Timesten - Replication (High Availability, Workload distribution)

TimesTen replication enables to achieve: (near-continuous|High) availability or workload distribution by replicating transactions between IMDB TimesTen databases. Type of replication Asynchronous...



Share this page:
Follow us:
Task Runner