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:
- KPEDBG_HDL_PUSH_FCPTRMAX;
- KPEDBG_HDL_POP_FCPTR;
- KPEDBG-...TLSORA-24550 and smth else;
- No errors sometimes.
Well, previously I've created tablespaces for my future benchmark user:
- alter session set container=XEPDB1 (that's the name of pluggable database);
- create tablespace tpcctab datafile 'tpcctab.dat' size 10G autoextend on;
- create temporary tablespace tpcctemp tempfile 'tpcctemp.dat' size 5G autoextend on;
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
The problem is actual. Any ideas how to resolve? By the way, we can not move to Enterprise edition(((
CodePudding user response：
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.