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
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
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.