sanjay

Steve, Thank you very much. Issue resolved after setting the scale factor in the driver script to the same value as the schema build. I need one more help regarding How to calculate grometric mean ? Please provide the details... Regards Sanjay

Steve, Thanks for quick reply. I did a mistake in setting the scale factor in the driver script to the same value as the schema build. The scale factor set to 1 where as the scale factor for the schema build is 300. Currently importing the tpch schema from export dump and will extecute the power test with refresh function and will set the correct scale factor as 300 . Update you soon. Regards Sanjay

Hi Steve , I am working on TPC-H workload on Oracle 19c database for the first time. Created a new database with Scale factor of 300 and executed the power test as per the HammerDB documentation. The driver output file is attached. Select the refresh function TRUE and executed the workload with one virtual user. As soon as the test begins, getting ORA-02291 error continuously. Hammerdb Log @ Sun Oct 13 05:09:34 EDT 2019 +-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+-+- Timestamp 1 @ Sun Oct 13 05:10:33...

Hi Steve, I need to run DSS workload on Oracle 19c database. Request to provide the link to download "hammerdb_oracle_dss.pdf" file as this document explains prerequisites and running power tests and throughput tests. Regards Sanjay

Steve, Thanks for the reply. I have used tnanames using SCAN and connected to multiple instances and ran the workload on all the 4 hammerdb clients, but, finally only one hammerDB client will provide the TPMs and NOPMs. Can you please brief how to use Master/Slave mode when using the GUI ? I can try the option and will provide an update. Thanks Sanjay

Steve, Installed Oracle 18c GI standalone database and build DB with 5000 warehouse. I am running the TPC-C workload using 20 virtual users. As soon as the test starts suddenly the Oracle VM cpu utilization reaches to 100%. I checked the CPU utilization using top command where it shows 20 Oracle processes constantly utilizing 60% CPU utilization during the test. Attaching the top output and init parameters Please advise. /Sanjay

Steve, I have created a 4-node Oracle RAC database and build the DB with 5000 warehouses (TPC-C workload). Created 4 HammerDB clients and connected to each DB instances using separate TNS alias ( not used SCAN). When I started the test with 100 virtual users on all the 4 HammerDB clients, it will run on only one HammerDB client. Is it possible to use multiple HammerDB clients on Oracle RAC database to do more transactions ? if yes, please suggest Thanks Sanjay