TPC-Council / HammerDB

HammerDB Database Load Testing and Benchmarking Tool
http://www.hammerdb.com
GNU General Public License v3.0
545 stars 115 forks source link

Virtual user scale up not working in TPROC-C workload #604

Closed Ora-DBA closed 10 months ago

Ora-DBA commented 10 months ago

Recently I'm using HammerDB benchmarking for Oracle 19c database. While running TPROC-C workload, with single virtual user test is running fine. When we scale up virtual user more than 1 then GUI hammerdb getting closed suddenly without showing any errors or warnings.
Is this expected behaviour or any environmental changes required to get it done?

Environment details as below. HammerDB Version :- Version: 4.8 HammerDB Interface :- GUI Operating System:

Database Server :

sm-shaw commented 10 months ago

Hi, Yes this long-standing Oracle bug is in the release notes:

Oracle on Windows: Oracle Bug 12733000 OCIStmtRelease crashes or hangs if called after freeing the service context handle

to fix put this in your windows client SQLNET.ORA

SQLNET.AUTHENTICATION_SERVICES = (NTS) DIAG_ADR_ENABLED=OFF DIAG_SIGHANDLER_ENABLED=FALSE DIAG_DDE_ENABLED=FALSE

Ora-DBA commented 10 months ago

Thank you Steve for quick response. after putting above settings in SQLNET.ORA, solved my issue. thanks again !!