Storage Provisioning for TimesTen

Storage provisioning is the process of allocating server storage space.

• TimesTen installation storage allocation: A TimesTen installation includes all of the software.

  Plan to allocate at least 1.5 GB for each TimesTen installation. If you run multiple instances on the same system, they can all share a single TimesTen installation. In order to incorporate software version upgrades, you should provision double that amount of space, plus some additional space.

• TimesTen instance storage allocation: Each TimesTen instance runs its own set of daemon processes (with associated daemon log files).

  Plan to allocate at least 256 MB for each TimesTen instance.

• Checkpoint files: Each TimesTen database requires disk space for two checkpoint files, each of which is stored in the directory that is specified with the DataStore attribute. As each checkpoint file grows on the file system, it never decreases in size. This can result in the size of each checkpoint file being equal to the maximum size that the database has ever reached in the permanent memory region. Thus, you should plan as though each checkpoint file occupies approximately the same amount of space as defined for permanent memory (as defined with the PermSize connection attribute).

  Plan to allocate twice the total permanent space of your databases plus 30%.

  Note:

  For TimesTen, you can set the Preallocate connection attribute to 1 to have TimesTen reserve file system space at connect time for checkpoint files. This is useful for large databases, which ensures that the file system always has room for the checkpoint files as data is added to the database. For more information, see Preallocate in the Oracle TimesTen In-Memory Database Reference.

• Transaction log files: Transaction log files are the most difficult space requirement to estimate. See Storage Provisioning for Transaction Log Files for how to plan for space provisioning for transaction log files.