Have a good day, guys and girls!) Using HammerDB for Oracle benchmarking, I have this connection settings: > diset connection instance IP_of_server:1521/XEPDB1 ... this messages from start and end snapshots: > Vuser 1:Start Snapshot 30 taken at 06 JUL 2022 16:58 of instance **xe** (1) of database **XE** (691444369) > Vuser 1:End Snapshot 31 taken at 06 JUL 2022 17:00 of instance **xe** (1) of database **XE** (691444369) ... and this result message: > Vuser 1:TEST RESULT : System achieved **12248 NOPM from 0 Oracle TPM** I use HammerDB 4.4, Oracle XE 21c and **pluggable** database XEPDB1. According to Oracle docs, starting from version 12.2 there are separated AWR snapshots for CDB and PDB - and AWR PDB snapshots are default disabled. Well, I've executed the code below: alter session set container=XEPDB1; alter system set awr_pdb_autoflush_enabled=true; conn system/; alter system set AWR_SNAPSHOT_TIME_OFFSET=1000000 scope=both; ... and then restart all 5 Oracle services. No effect. Then I've tried to modify HammerDB oraoltp.tcl **line 2533:** from this: SELECT INSTANCE_NUMBER, INSTANCE_NAME, DB_NAME, DBID, SNAP_ID, TO_CHAR(END_INTERVAL_TIME,'DD MON YYYY HH24:MI') FROM (SELECT DI.INSTANCE_NUMBER, DI.INSTANCE_NAME, DI.DB_NAME, DI.DBID, DS.SNAP_ID, DS.END_INTERVAL_TIME FROM DBA_HIST_SNAPSHOT DS, DBA_HIST_DATABASE_INSTANCE DI WHERE DS.DBID=DI.DBID AND DS.INSTANCE_NUMBER=DI.INSTANCE_NUMBER AND DS.STARTUP_TIME=DI.STARTUP_TIME ORDER BY DS.END_INTERVAL_TIME DESC) WHERE ROWNUM=1" to this: SELECT INSTANCE_NUMBER, INSTANCE_NAME, DB_NAME, DBID, SNAP_ID, TO_CHAR(END_INTERVAL_TIME,'DD MON YYYY HH24:MI') FROM (SELECT DI.INSTANCE_NUMBER, DI.INSTANCE_NAME, DI.DB_NAME, DI.DBID, DS.SNAP_ID, DS.END_INTERVAL_TIME FROM AWR_PDB_SNAPSHOT DS, AWR_PDB_DATABASE_INSTANCE DI WHERE DS.DBID=DI.DBID AND DS.INSTANCE_NUMBER=DI.INSTANCE_NUMBER AND DS.STARTUP_TIME=DI.STARTUP_TIME ORDER BY DS.END_INTERVAL_TIME DESC) WHERE ROWNUM=1" So, I've replaced **DBA_HIST_SNAPSHOT** with **AWR_PDB_SNAPSHOT** and **DBA_HIST_DATABASE_INSTANCE** with **AWR_PDB_DATABASE_INSTANCE** - as follows from this Oracle 12.2 feature. As result it has got 0 NOPM and 0 TPM as well. So what have I done wrong and how to fix this 0 TPM? Any ideas, please?)(

I am working with Hammer DB to connect to remote DB2 AS400. However, I am running into issue in build schema. [IBM][CLI Driver][AS] SQL0204N "QSYS.ANAND" is an undefined name. SQLSTATE=42704 user ANAND is present as I am able to connect to it using DBeaver. In script editor I have tried to narrow down the issue by using print. The above issue is at proc CreateTables { db_handle num_part count_ware tspace_dict } { ... ... } else { puts "db2 else" db2_exec_direct $db_handle $sql($i) } } Prior to this I am seeing connection established message in virtual user output.

I have Oracle XE 21c and HammerDB 4.4. The task is to benchmark database. Oracle Database 21c Express Edition Release 21.0.0.0.0 - Production Version 21.3.0.0.0 Well, because of that I've done the command below after 'sqlplus system/pass_of_sys': alter session set container=XEPDB1; (that's the name of pluggable DB); create tablespace tpcctab datafile 'tpcctab.dat' size 8G autoextend on; create temporary tablespace tpcctemp tempfile 'tpcctemp.dat' size 4G autoextend on; And I've created HammerDB creating schema script which runs on local machine: dbset bm TPROC-C dbset db ora diset connection system_user system diset connection system_password pass_of_sys diset connection instance 192.168.192.11/XEPDB1 diset tpcc tpcc_user tpcc diset tpcc tpcc_pass tpcc diset tpcc tpcc_def_tab tpcctab diset tpcc tpcc_def_temp tpcctemp diset tpcc count_ware 4 diset tpcc num_vu 3 buildschema .... and driver script which runs on another machine in the same network: dbset db ora dbset bm TPROC-C diset connection system_user system diset connection system_password pass_of_sys diset connection instance 192.168.192.11/XEPDB1 diset tpcc tpcc_user tpcc diset tpcc tpcc_pass tpcc diset tpcc ora_driver timed diset tpcc rampup 1 diset tpcc duration 1 diset tpcc checkpoint true diset tpcc total_iterations 1000 diset tpcc allwarehouse true loadscript vuset vu 3 vuset logtotemp 1 vucreate vurun Every time first script creates tpcc user, both then executes several transactions and fails - even if to write **'diset connection instance 192.168.192.11:1521/XEPDB1'**, Oracle XE returns different errors, every time error is different: - KPEDBG_HDL_PUSH_FCPTRMAX; - KPEDBG_HDL_POP_FCPTR; - KPEDBG-...TLSORA-24550 and smth else. Moreover, rampup period does not start. If in driver script in string **'diset tpcc total_iterations 1000'** write more than 1000, or in **'diset tpcc duration 2'** write more than 1 - driver script fails even with no transaction with the same error codes.... And of course I know about XE limitations. So WHAT should I do to come over that task? Any ideas, please?((

I'm trying to use HammerDb 3.0 to get a baseline to compare my servers. I can create the Db, schema, data and items required no problem. I can execute the test and see that it's running. When the script completes it give me a NOPM number but says TPM is zero. When it's running the Transaction counter doesn't graph anything either. Is this a known or common problem?

I'm trying to generate workload from our production databases but rather than running a trace file in production, I would prefer using the AWR tables since we have a license for it. Is it possible? Thank you.