Extract(Read) > Transform(Test&Apply) > Load(Learn) Blog

March 8, 2007

Oracle TimesTen In-Memory Database-Microseconds Indeed Counts

Filed under: Oracle How To — H.Tonguç Yılmaz @ 1:40 pm

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

    Comment by yohanyudanara — August 31, 2007 @ 1:45 am | Reply

  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.

    Comment by H.Tonguç Yılmaz — August 31, 2007 @ 4:37 am | Reply


RSS feed for comments on this post. TrackBack URI

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

Blog at WordPress.com.

%d bloggers like this: