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.

The following ttIsql commands are commonly used when troubleshooting:

  • dssize prints database size information.

  • showplan prints the optimizer execution plans for selects, updates, and deletes in this transaction.

  • timing prints query timing.

  • optprofile prints the current optimizer flag settings and join order.

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