Oracle-DB: Run TPC benchmark with hammerdb on Standard Edition
we are running on Oracle Linux and want to benchmark a SE2 instance. Assuming an DB Docker instance is already running on port 1521. Start hammerdb container: docker run --network=host -it --name hammerdb tpcorg/hammerdb:oracle bash Create a config script config.tcl: # Select the Oracle database. dbset db ora # Select the TPC-C benchmark. dbset bm TPC-C # Oracle DBA user (e.g., SYSTEM) diset connection system_user SYSTEM # DBA user's password diset connection system_password oracle # Your TNS Service Name or Easy Connect diset connection instance ORCLPDB1 # Scaling Factor (Number of Warehouses), e.g. 100 diset tpcc count_ware 1 # Virtual Users for schema build/load, e.g. 8 diset tpcc num_vu 1 # Benchmark schema user (will be created) diset tpcc tpcc_user TPCC # Benchmark schema password diset tpcc tpcc_pass pdcc # Tablespace name for data. diset tpcc tpcc_def_tab USERS Create a schema build script build.tcl: puts "--- Loading Configuration ---" source config....