Using the ttIsql Utility

The ttIsql utility enables you to interactively execute SQL statements and report status information on your TimesTen database.

All TimesTen SQL operations can be executed from a ttIsql Command> prompt.

This example illustrates how to use the ttIsql utility.

% ttIsql database1
Copyright (c) 2019, 2021, Oracle and/or its affiliates. All rights reserved.
Type ? or "help" for help, type "exit" to quit ttIsql.

connect "DSN=database1";
Connection successful:
DSN=database1;UID=testuser;DataStore=/scratch/testuser/database1;
DatabaseCharacterSet=AL32UTF8;ConnectionCharacterSet=AL32UTF8;PermSize=128;
(Default setting AutoCommit=1)

You can then execute SQL statements or ttIsql commands at the Command> prompt. You can also call TimesTen built-in procedures. One useful procedure is ttConfiguration. When you call ttConfiguration, TimesTen displays the values of the connection attributes for your current database connection. For more information, see ttConfiguration in the Oracle TimesTen In-Memory Database Reference.

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:

dssize prints database size information.

See Displaying Database Structures Using ttIsql in the Oracle TimesTen In-Memory Database Operations Guide.
showplan prints the optimizer execution plans for selects, updates, and deletes in this transaction.

See Using ttIsql to View and Change Query Optimizer Plans 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 Using ttIsql to View and Change Query Optimizer Plans in the Oracle TimesTen In-Memory Database Operations Guide.

For the full list of ttIsql features, see ttIsql in the Oracle TimesTen In-Memory Database Reference.