Timesten - Checkpoint

Timesten Component


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 dual checkpoint files for additional safety, in case the system fails while a checkpoint operation is in progress.

Normal disk file systems are used for checkpoints.

TimesTen automatically performs background checkpoints based on the settings of the connection attributes:

  • CkptFrequency
  • and CkptLogVolume.

TimesTen also checkpoints the database when the last application disconnects. Applications can also checkpoint a database directly to disk by invoking the ttCkptBlocking built-in procedures described in the Oracle TimesTen In-Memory Database Reference.

Temporary databases are never fully checkpointed to disk, although Checkpoint operations can have significant overhead for permanent databases, depending on database size and activity, but have very little impact for temporary databases. Checkpoints are still necessary to remove transaction log files.

Discover More
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 - (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 - DBI (Database Information) file

Every TimesTen data store has a DBI (Database Information) file associated with it. The DBI file is an internal catalog, storing information every data store which exists for this installation (instance)...
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 - Monitor

The ttisql monitor command displays all of the information provided by the dssize command plus additional statistics on the number of: connections, checkpoints, lock timeouts, commits, rollbacks...
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 - Start/Stop a database

The concept of starting and stopping a TimesTen in-memory database is different from that of a disk-based RDBMS. For TimesTen, a database is ready for use by an application after the database is loaded...
Timesten Component
Timesten - Sub-daemons

TimesTen assigns a separate subdaemons to each database to perform operations including the following tasks: Manage databases. Loading the database into memory from a checkpoint file on disk Recovering...

Share this page:
Follow us:
Task Runner