Technical data

Using the ttStatus utility
1-2 Oracle TimesTen In-Memory Database Troubleshooting Procedures Guide
You can then execute SQL statements or ttIsql commands at the Command> prompt.
"Using the ttIsql Utility" in the Oracle TimesTen In-Memory Database Operations Guide
describes how to use the most common ttIsql commands. The following ttIsql
commands are commonly used when troubleshooting:
■ monitor formats the contents of the SYS.MONITOR table.
See "Displaying data store information" in the Oracle TimesTen In-Memory Database
Operations Guide.
■ dssize prints data store size information.
See "Displaying data store information" in the Oracle TimesTen In-Memory Database
Operations Guide.
■ showplan prints the optimizer execution plans for selects/updates/deletes in this
transaction.
See "Viewing and changing query optimizer plans" in the Oracle TimesTen
In-Memory Database Operations Guide.
■ isolation sets or displays the isolation level.
See "Working with transactions" in the Oracle TimesTen In-Memory Database
Operations Guide.
■ timing prints query timing.
See "Timing ODBC function calls" in the Oracle TimesTen In-Memory Database
Operations Guide.
■ optprofile prints the current optimizer flag settings and join order.
See "Viewing and changing query optimizer plans" in the Oracle TimesTen
In-Memory Database Operations Guide.
For the full list of ttIsql features, see the lists of options and commands under the
description of the ttIsql utility in the Oracle TimesTen In-Memory Database Reference.
Using the ttStatus utility
Use the ttStatus utility to check the status of the TimesTen daemon and the state of
all TimesTen -connections.
Example 1–2 ttStatus shows TimesTen daemon is not running
In this example, the output from ttStatus indicates that no TimesTen daemon is
running. If the daemon has stopped unexpectedly, see "No response from TimesTen
daemon or subdaemon" on page 2-2 for troubleshooting information.
On Windows:
C:\>ttStatus
ttStatus: Could not connect to the TimesTen service.
If the TimesTen service is not running, please start it by running "ttDaemonAdmin
-start".
On UNIX platforms:
$ ttStatus
ttStatus: Could not connect to the TimesTen daemon.
If the TimesTen daemon is not running, please start it
by running "ttDaemonAdmin -start".