Oracle TimesTen In-Memory Database-Microseconds Indeed Counts

Today I downloaded and installed Oracle TimesTen 7.0 In-Memory Database on Linux by following these presentations;

How to install Oracle TimesTen 7.0 on Linux
How to create an Oracle TimesTen 7.0 Database on Linux

and this documentation; TimesTen 7.0 Installation Guide

Code listing 70 : TimesTen Installation Notes

First benchmark results using the demo C code tptbm supplied by Oracle are very intresting, remember this is just an Oracle Enterprise Linux installed desktop pc with a single cpu after all :)

[oracle@tcellhost performance]$ ./tptbm -proc 2 -read 85 -insert 10 tptbmdata_tt70
Connecting to the data source
Populating benchmark data store
Waiting for 2 processes to initialize
Beginning execution with 2 processes: 85% read, 5% update, 10% insert

Elapsed time: 1.4 seconds
Transaction rate: 14673.5 transactions/second
[oracle@tcellhost performance]$ ./tptbm -proc 4 -read 85 -insert 10 tptbmdata_tt70
Connecting to the data source
Populating benchmark data store
Waiting for 4 processes to initialize
Beginning execution with 4 processes: 85% read, 5% update, 10% insert

Elapsed time: 1.8 seconds
Transaction rate: 21990.1 transactions/second
[oracle@tcellhost performance]$ ./tptbm -proc 4 -read 60 -insert 20 tptbmdata_tt70
Connecting to the data source
Populating benchmark data store
Waiting for 4 processes to initialize
Beginning execution with 4 processes: 60% read, 20% update, 20% insert

Elapsed time: 2.2 seconds
Transaction rate: 18248.2 transactions/second

Next steps include replicating data between Oracle and TimesTen over Global Cache Connect option and of course for persistency stress shutting down the electricty of pc during load :)

Testing Information : the scripts mentioned are tested on Oracle Database 10g Enterprise Edition Release 10.2.0.1.0

Refences Used :
Oracle Magazine Article “When Microseconds Count” by Mr.Jonathan Gennick
Oracle TimesTen In-Memory Database Product Center

2 Comments

  1. I need to benchmark oracle timesten 7 against oracle 10g express.

    Are there any tools I could use?

    I’ve tried swingbench, but I could’t make it work for timesten 7.
    I can’t figure out the connection string for timesten 7.

    Could u kindly help me?

    Thank u very much

  2. yohanyudanara please provide some details of your need; “to benchmark oracle timesten 7 against oracle 10g express”

    there are some already available benchmark tools like tptbm I used coming with TimesTen.

Leave a Reply to yohanyudanara Cancel 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 )

Google photo

You are commenting using your Google 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