-
HammerOra can not access AWR snapshots for a RAC DB when instance 1 is down, due to errors in the SQL statement which selects snapshot IDs. The SQL does a cartesian join instead of an inner join and returns incorrect results which are not normally a problem as long as all instances in a RAC DB are open. I have supplied my revised version of the SQL statement below for your information. The...
2009-10-20 02:21:23 UTC by nobody
-
Hi,
The option for keyandthink is by default set to "on or off", the reason is because the values are the same as the ones in the TPC-C specification. There is nothing to stop you experimenting with changing it though in the driver script, just one of the advantages of Open Source! I would say though that to use the 'official values' you do need a huge database with hundreds of...
2009-10-01 19:37:34 UTC by smshaw
-
Missed on completing the foll.:
Our main objective is to run 'x' load on both hardwares (the machines have ample cpu capacity). And then compare the time taken and cpu utilization for that 'x' load on both hardwares. And so we want the test to last about an hour and cpu utilization to hit somewhere around 40-50%.
thanks.
2009-09-30 19:15:47 UTC by puravc
-
Thanks Steve.
We are testing with keyandthink set to false. But that is by intent - the reason being, when we tried with keyandthink set to true, it hardly stressed the CPU i.e. cpu usage was very low. Our main objective is to run 'x' load on both hardwares (the machines have ample cpu capacity).
By 1 thread are you referring to 1 vuser? If not, thread means the thread on server running...
2009-09-30 19:13:38 UTC by puravc
-
Hi,
Yes the warehouse assignment code is random so you can end up with multiple users per warehouse. The main question is are you using keying and thinking time to simulate what takes place in a real TPC-C type test or are you running with keying and thinking time turned off? If keying and thinking time is turned off even a single user has the ability to drive a a significant amount of CPU...
2009-09-24 15:17:07 UTC by smshaw
-
Hi,
It is important to note that a core dump indicates that something within TCL itself is breaking. First thing to check is that you have the OS resources to support the users you want to configure, the most common limit is the stack size, so as the root user set the system limit
etc/security/limits.conf
#* soft core 0
#* hard rss.
2009-09-24 14:54:22 UTC by smshaw
-
We are trying to compare the performance on 2 different hardwares. RDBMS is Oracle 10g R2. What we observe is that, huge amount of time is being spent on row lock contention.
Our understanding is that this happens because vusers are assigned warehouses randomly. With 200 warehouses, we tried with 50 vusers, 100 vusers, 500 vusers & 750 vusers. With 500 & 750 vusers we understand that...
2009-09-24 13:45:02 UTC by puravc
-
Hi Steve,
We are facing the same error on RHEL 5 but not consistently. At times its fine but on most occassions it errors. We tried with 2000 virtual users as well with 500 vusers. Generated the core dump and the stack trace shows the foll.:
(gdb) where
#0 0x00002b2f3abce704 in DisplayText () from ./lib/libtk8.5.so
#1 0x00002b2f3ae07c8b in TclServiceIdle () from ./lib/libtcl8.5.so
#2...
2009-09-23 15:23:11 UTC by puravc
-
We got the solution.
Actually we had installed 32 bit software on 64 bit machine but now we have installed 64 bit software and now it working fine.
chirag.
2009-09-15 07:38:58 UTC by mrchshah
-
We have installed Hammerora 2.3 on Red Hat Enterprise Linux Server release 5.3 (Tikanga) and it installed successfully.
We are also able to create tpcc schema but when we tried to create virtual user from console it gave following error.
The xml in config.xml is well-formed, applying variables
Unmatched Background Error - can't create a new thread
while executing...
2009-09-15 06:51:44 UTC by mrchshah
