Timesten - Direct Connection

Timesten Component


When the client application resides on the same machine as the TimesTen Server, you can use shared memory for the inter-process communication (IPC).

The best response time is achieved with TimesTen running in-process with the application (also known as “direct mode”).

This can be useful for:

  • performance purposes
  • or to allow 32-bit client applications to communicate with a 64-bit database on the server.

The TimesTen Data Manager driver is used with direct connection.

A direct JDBC connection contains the word direct in the Jdbc Url such as:



In the ttendaemon.options:

  • The -serverShmIpc entry tells the TimesTen Server to accept a client connection that intends to use a shared memory segment for IPC.
  • The -serverShmSize size tells the TimesTen Server to create a shared memory segment of the specified size in MB. If this entry is missing, the TimesTen Server creates a shared memory segment of 64MB.


maximum of 16 different instances

TimesTen supports a maximum of 16 different instances of the shared memory IPC-enabled server. If an application tries to connect to more than 16 different shared memory segments it receives an ODBC error.

Documentation / Reference

Discover More
Sqldeveloper Connection Timesten
Timesten - Connection

An application can connect to the IMDB Cache or TimesTen database by: direct link and by client/server connections. You may see up to 2047 connections. While the best response time is achieved...
Timesten Component
Timesten - How to set up the Timesten Cache ?

Steps to set up the Timesten Cache to cache data of an Oracle Database. Before you cache Oracle data in a TimesTen database, you must perform certain tasks: either outside SQL Developer using command-line...
Timesten Component
Timesten - ODBC Driver

TimesTen includes the following TimesTen ODBC drivers: TimesTen Data Manager driver for use with direct connect applications. TimesTen Client driver for use with client/server applications. ...
Timesten Component

Sample tnsnames.ora found in the directory TimesTen_Base/network/admin/samples with TNS entry: for the cache of an oracle database for a direct and client connection for the DSN defined in the sys.odbc.ini...

Share this page:
Follow us:
Task Runner