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:
- 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: 
HammerDB benchmark script:
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.
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.
- mysql database comparison before insert
- Does MySQL ignore null values on unique constraints?
- How to skip certain database tables with mysqldump?
- Default username and password for Oracle database
- Update TransactionId based on mapping table data
- Why INNER JOIN not equal (!=) hang forever
- Neo4j process running in background even when the docker container isn't running
- CakePHP - how to apply translate behavior to existing database?
- Best way to structure a database for scaling
- Both nodes on my side are cold nodes, but the return information:Valid node is not enough, need: 1, but found: 1
- How to avoid circular relations in postgres using cycle detection
- Get totals for top 5 elements in GROUP BY, and then the rest of the groups in a single total
- INSERT and UPDATE the Values into the table based on condition
- Queries and best practices: How to query multiple tables and return object using Convex.dev?
- java.sql.SQLIntegrityConstraintViolationException: Column 'msg' cannot be null
- DB2 UTF8 storage configuration
- What's the difference between MySQLdb, mysqlclient and MySQL connector/Python?
- Inserting dummy data into Postgres table
- MongoDB Atlas CMD_NOT_ALLOWED: grantRolesToUser and dropDatabase Permissions Issue
- "The transaction log for database is full due to 'LOG_BACKUP'" in a shared host
- What is the importance of implementing binary search trees (BST) for our database?
- How can I scrape data efficiently and clean it?
- Why is PostgreSQL sorting a seemingly already sorted result set?
- Error Connection to localhost:5432 refused. Check that the hostname and port are correct and that the postmaster is accepting TCP/IP connections
- How can I migrate data from one PostgreSQL database to another (with slightly different table/column names)?
- how to enter the data only if all instructions are correct in my migration files?
- What is the most suitable data type for a column in a table?
- database primary key
- Is there a "with conn.cursor() as..." way to work with Sqlite?
- python + json file saving