Oracle TimesTen In-memory Database Quick Commands & Tips

Commands to Start TimesTen Service:

./ttdaemonadmin -start
./ttdaemonadmin -startserver

Commands to Stop TimesTen Service:

./ttdaemonadmin -stopserver
./ttdaemonadmin -stop

Command to get status of TimesTen DB:


Note: Important to notice is whether the Data is loaded into RAM or not

Command to load the data into RAM:

./ttAdmin -connstr “dsn=DATA_SOURCE_NAME” -ramLoad

Command to unload data from RAM:

./ttAdmin -connstr “dsn=DATA_SOURCE_NAME” -ramUnload

Command to run quick query on the TimesTen DB:

./ttIsql -connstr “dsn=DATA_SOURCE_NAME” -e “SQL_STATEMENT_1; SQL_STATEMENT_2;”

Location of Log Files for Troubleshooting:

TimesTen/t1122/info, the two most important files are tterrors.log and ttmesg.log

If you would like to know more about Oracle TimesTen Database:


Product Documentation:

About SoCRaT

Systems Engineer, OSS & Linux Geek
This entry was posted in Oracle and tagged , , , , , . Bookmark the permalink.

Leave a Reply

Fill in your details below or click an icon to log in: Logo

You are commenting using your account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s