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:

./ttstatus

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:

Overview: http://www.oracle.com/us/products/database/timesten/overview/index.html

Product Documentation: http://docs.oracle.com/cd/E13085_01/doc/index.htm

Advertisements

About SoCRaT

Research Support and Infrastructure 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:

WordPress.com Logo

You are commenting using your WordPress.com 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 )

Google+ photo

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

Connecting to %s