Displays information that describes the current state of TimesTen.

The command displays:

  • State of the TimesTen daemon process and all subdaemon processes.

  • Names of all existing TimesTen databases.

  • Number of connections currently connected to each TimesTen database.

  • The RAM, cache agent and replication policies.

  • The status of the start up scripts and which command needs to be used to start the daemon.
  • TimesTen cache agent status.

  • The status of PL/SQL.

  • The key and address of the shared memory segment used by TimesTen.

  • The address, key and ID of the shared memory segment used by PL/SQL.

  • Whether the TimesTen instance is accessible by a specified operating system group or accessible by anyone. For more details, see the daemon options in the Managing TimesTen Daemon Attributes in Oracle TimesTen In-Memory Database Operations Guide.

  • Miscellaneous status information.

If you specify a connection string or DSN, ttStatus outputs only the information for the specified database.

Required Privilege

This utility requires no privileges.

Usage in TimesTen Scaleout and TimesTen Classic

This utility is mainly for use in TimesTen Classic. You can only use it for TimesTen Scaleout to retrieve information about the local instance.


ttStatus {-h | -help | -?}
ttStatus {-V | -version}
ttStatus [-v] [-r secs] [-[no]pretty] [-gridbrief]
ttStatus [-r secs] [-[no]pretty] {DSN | -connStr connection_string}


ttStatus has the options:

Option Description




Prints usage information and exits.

-V | -version

Prints the release number of ttStatus and exits.

-connStr connection_string

An ODBC connection string that specifies a database location, driver, and optionally other connection attribute settings.


An ODBC data source name of the database for which to get status.


Prints detailed information that is useful for TimesTen customer support.

-r secs

Enables ttStatus to continue running. Updates status report every secs seconds.


The -pretty option (default) is for "pretty" formatting, which uses the values of the ConnectionName connection attribute. The -nopretty option is to not use pretty formatting.


Removes the lists of connections for every existing database or element from the displayed information.

Sample Output

When you call the procedure, a report that describes the current state of the system is displayed to stdout. To get the status for the cachedb1_18110 DSN:

% ttstatus cachedb1_18110
TimesTen status report as of Thu May 02 19:45:43 2013

Daemon pid 5280 port 53392 instance tt1811
TimesTen server pid 3940 started on port 53393
Open for user connections
Data store cachedb1_18110
There are 12 connections to the data store
Shared Memory KEY Global\cachedb1_18110.c|. . .HANDLE 0x254
PL/SQL Memory KEY Global\cachedb1_18110.c|. . . HANDLE 0x258 Address 0x5B8C0000
Type            PID     Context     Connection Name              ConnID
Process         5196    0x01066a58  cachedb1_18110                     1
Subdaemon       3912    0x00b2c398  Manager                        2047
Subdaemon       3912    0x00b7e4a0  Rollback                       2046
Subdaemon       3912    0x015d25e8  Flusher                        2045
Subdaemon       3912    0x015e46b0  Monitor                        2044
Subdaemon       3912    0x016767f8  Deadlock Detector              2043
Subdaemon       3912    0x016888c0  Checkpoint                     2041
Subdaemon       3912    0x0d350578  Aging                          2042
Subdaemon       3912    0x0d362640  Log Marker                     2040
Subdaemon       3912    0x0d4347c8  AsyncMV                        2039
Subdaemon       3912    0x0d446890  HistGC                         2038
Subdaemon       3912    0x0d458958  IndexGC                        2037
Replication policy  : Manual
Cache Agent policy  : Manual
PL/SQL enabled.
Accessible by group . . .
End of report


  • While primarily intended for use by TimesTen customer support, this information may be useful to system administrators and developers.

  • The ttStatus utility only reports the RAM policy if it is not inUse.

See Also