databaseoracle-databasebenchmarkingoracle-xehammerdb

Oracle XE configuring for benchmark

Have a good day.

The task is to configure Oracle XE for performance benchmark using HammerDB. Well, the HammerDB script for creating schema and driver script are both done. But trying to create schema or run a benchmark Oracle XE returns me different errors.

Error can be:

  1. KPEDBG_HDL_PUSH_FCPTRMAX;
  2. KPEDBG_HDL_POP_FCPTR;
  3. KPEDBG-...TLSORA-24550 and smth else;
  4. No errors sometimes.

Well, previously I've created tablespaces for my future benchmark user:

Well, those statements are done correct and HammerDB tpcc user creates correct. Then Oracle XE returns me one of errors above.

HammerDB creating schema script: 1

HammerDB benchmark script:

2

Additionally I've added in initXE.ora:

mts_dispatchers="(address=(partial=true)(protocol=tcp)(host=192.168.192.11.1)(port=1521))(dispatchers=8)"

Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0

Any ideas how to resolve? By the way, we can not move to Enterprise edition.

Solution

  • KPEDBG_HDL_PUSH_FCPTRMAX;

    You have data structures in your Database which is protected. If you have (i. e. in a Benchmark) concurrent accesses by multiple threads in this structure this failure will be raised. You can lower down the threads in the benchmark. Push means you will ad something in the stack.

    KPEDBG_HDL_POP_FCPTR

    Looks similar to me. I will guess, this failure will be raised if you have concurrent accesses by multiple threads. Pop means you will remove something in the stack.

    2 different failures same cause: multiple threads in a protected data structure.

    KPEDBG_POP_KGPPTR_TLSORA-24550

    That is an official issue in Oracle. You could search for ora-24550. An update should help to solve this problem.

    https://community.oracle.com/tech/developers/discussion/889345/ora-24550-signal-received-unhandled-exception-code-e0434f4d-flags-1