What's New

List of the Oracle TimesTen In-Memory Database new features documented in this guide, with descriptions and links to more information.

New features in release 22.1.1.17.0

• Previously, you could only provide credentials for a user when opening a connection to the TimesTen database by providing the user name and password individually in a client DSN or using connection attributes. For a cache administration user, you were able to provide credentials by providing the cache administration user name and both of its passwords to the TimesTen and Oracle databases individually in a client DSN or using connection attributes. Now, you can store user credentials within an Oracle Wallet where the wallet location is provided when opening a connection. The preferred method is storing credentials in an Oracle Wallet.

  We enabled this new method by implementing the following features:
  • New functionality for the ttUser utility. Traditionally, ttUser has let you generate a hashed password value for the PWDCrypt connection attribute. Now, it also lets you store user IDs and passwords in a user-managed Oracle Wallet.
  • New PwdWallet general connection attribute. It lets you retrieve user names and associated passwords from a user-managed Oracle Wallet.
  • New CacheAdminWallet cache first connection attribute. It specifies that credentials for the Oracle cache administration user that are registered with the ttCacheUidPwdSet built-in procedure are stored in a system-managed Oracle Wallet.
• TimesTen now supports FIPS 140-2 encryption. For client/server and replication connections, you can enable the FIPS 140-2 mode using the new ssl_fips_140 configuration attribute. For symmetric encryption between TimesTen processes, use the new db_fips_140 configuration attribute. See TimesTen Instance Configuration File.
• The new ttCacheInfo utility returns change-log table information for all Oracle Database tables cached in a cache group with autorefresh and information about Oracle Database objects used to track DDL statements issued on cached Oracle Database tables. The output provided by this utility is primarily intended for use by TimesTen customer support.

New features in release 22.1.1.9.0

The ttInstanceModify utility now includes the -serverWallet option, which enables you to specify and validate a new location for the server wallet and to modify the entry of the new server wallet directory in the timesten.conf file.

New features in release 22.1.1.7.0

The ttSchema utility now selects only objects within the current schema by default when a user without ADMIN privilege runs the utility. This change avoids access errors when the user tries to describe objects without the appropriate privileges. The user can still attempt to describe objects by including a different selection pattern argument. The pattern % will revert to the previous behavior, but using patterns that include objects in other schemas may result in access errors.

New Features in Release 22.1.1.3.0

The -create-server-certificate option of the ttExporter utility supports two options that let you specify the Common Name (CN) and the Subject Alternative Name (SAN) for the server certificate. These options are -certificate-common-name and -certificate-alt-names respectively. If you are using the Exporter with the TimesTen Kubernetes Operator, these options are required. See ttExporter.

New Features in Release 22.1.1.1.0

• You can perform a fast patch upgrade. This involves performing operations to modify a TimesTen instance to point to a new installation while ensuring the shared memory segment remains in memory. The ttAdmin -ramload command includes the optional -enduring option. The ttAdmin utility also contains the -shmDetach -shmLoad and -shmAttach options.

• The ttShmSize utility enables you to estimate the size of the shared memory needed. See the ttShmSize utility.

• The ttExporter utility enables Prometheus to monitor TimesTen health and operations. Prometheus is an open source systems monitoring and alerting toolkit. It collects and stores metrics from a variety of sources. It has its own time-series database and time-series query language. See the ttExporter utility.

• For TimesTen Scaleout, you can perform online upgrades to patch-compatible releases. This release adds the ttGridAdmin gridUpgrade command to simplify online and offline upgrade operations. See Upgrading a Grid in the Oracle TimesTen In-Memory Database Scaleout User's Guide for more information.
• TLS certificate management is supported in TimesTen Scaleout and TimesTen Classic. See Certificate Operations.
• You can configure the client/server buffer size. See the TTC_NetMsgMaxBytes and TTC_NetMsgMaxRows connection attributes.
• You can set a time limit in seconds for a transaction to complete with the TransactionTimeout connection attribute.
• As aging deletes rows, TimesTen frees empty pages and reuses empty slots on non-full pages. The ttPageLevelTableInfo built-in procedure shows the page allocation for each table to determine when TimesTen is reusing empty slots and freeing empty pages or if new pages are allocated to store new rows. See ttPageLevelTableInfo.