Running BenchmarkSQL against Oracle Database

Language: English | 简体中文

git clone https://github.com/cpyang/benchmarksql
cd benchmarksql
# Compile
ant
cp $ORACLE_HOME/jdbc/lib/ojdbc6.jar lib/oracle/
cd run
cp props/sample.oracle.properties oracle

Prepare the Python environment (uv) — needed for report graphs

The report scripts (run/generateReport.sh → run/generateGraphs.sh → run/misc/graph_generator.py) call python3 and require the packages in requirements.txt (pandas, matplotlib, tzdata, numexpr, bottleneck). Create a virtualenv once, from the repository root, with uv:

cd <benchmarksql>
uv venv --python 3.9 .venv
uv pip install --python .venv/bin/python -r requirements.txt

Then activate it whenever you generate reports:

source .venv/bin/activate
cd run
./generateReport.sh my_result_YYYY-MM-DD_HHMMSS

On an offline / air-gapped host, install from the bundled wheel set (py39_wheels/, plus the uv binary in bin/) instead of the network:

uv pip install --python .venv/bin/python --offline --find-links py39_wheels/ -r requirements.txt

Modify configuration

conn=jdbc:oracle:thin:@localhost:11521:db11g
user=bmsql
password=bmsql
warehouses=2
loadWorkers=2
terminals=2

Create Oracle Schema

create user bmsql identified by bmsql
grant dba to bmsql
....

Generate Test Data

./runDatabaseBuild.sh oracle

Run Benchmark

./runBenchmark.sh oracle

Remove Test Data

./runDatabaseDestroy.sh oracle