Timesten - ttIsql

Timesten Component


ttIsql is an interactive SQL command line utility that allows developers to execute SQL statements to create, view, compile and run PL/SQL subprograms. Similar to SQL*Plus, ttIsql can also be used by database administrators for manage their databases.


ttISql -help


How to Connect

When connecting to the database using ttIsql, you can specify:

  • a DSN (Example in batch mode)
ttisql myDSN
  • a connection string
Command>connect "dsn=plsqldb; uid=pls; pwd=pls; oraclepwd=pls";

List of functions

Function Description Example
packages List the packages packages;
desc Describe the Dataabse Object desc MyPackage;
@ To start a procedure @TT_SCRIPTS/plsql_sql/5_call_workload.sql;

See syntax


1 extra arguments starting with

C:\Users\gerard>ttisql DI_TT_AGGR_STORE;
ttisql: Error: 1 extra arguments starting with 'DI_TT_AGGR_STORE;'
A non-option <DSN> or <CONNSTR> needs to be the last argument.

Just suppress the semicolon.

Documentation / Reference

Discover More
Timesten Component
Timesten - (Memory|Database) (Size|Space|Partition)

TimesTen manages database space using two separate memory partitions within a single contiguous memory space. One partition contains: permanent data and the other contains temporary data. ...
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...
Sql Developer Connection String
Timesten - Connection String

A Connection string is a way to define connection attributes that are not define in the DSN. According to the ODBC standard, when an attribute occurs multiple times in a connection string, the first value...
Timesten Component
Timesten - How to explain a query plan ? (Explain command|ttSqlCmdQueryPlan)

To explain a query and show a query plan, you can use: The ttIsql explain command for an individual SQL command. or the ttSqlCmdQueryPlan built-in procedure you get it from command cache (the...
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 - Isolation

Isolation is a ttIsql commands that gives the database isolation level.
Timesten Component
Timesten - Monitor

The ttisql monitor command displays all of the information provided by the dssize command plus additional statistics on the number of: connections, checkpoints, lock timeouts, commits, rollbacks...
Timesten Component
Timesten - User

There are four types of users in the TimesTen database: with all privileges who authenticate against the database who authenticate against the operating system who are used internally by the...

Share this page:
Follow us:
Task Runner