$export JAVA_TOOL_OPTIONS= -dfile.encoding =UTF8 [OracleMyASM benchmarkSQL-5.0]$Ant Picked up JAVA_TOOL_OPTIONS: -Dfile.encoding=UTF8 Buildfile: build.xml init: compile:

Compiling 11 Source Files to /soft/ TPCC/BenchmarkSQL-5.0 / Build

dist:

[mkdir] Created dir: /soft/tpcc/benchmarksql-5.0/dist
  [jar] Building jar: /soft/tpcc/benchmarksql-5.0/dist/BenchmarkSQL-5.0.jar

BUILD SUCCESSFUL Total time: 14 seconds db=oracle driver=oracle.jdbc.driver.OracleDriver user=mytest password=oracle warehouses=10 loadWorkers=4 terminals=10 //To run specified transactions per terminal- runMins must equal zero runTxnsPerTerminal=0 //To run for specified minutes- runTxnsPerTerminal must equal zero runMins=10 //Number of total transactions per minute limitTxnsPerMin=300 //Set to true to run in 4.x compatible mode. Set to false to use the //entire configured database evenly. terminalWarehouseFixed=true //The following five values must add up to 100 newOrderWeight=45 paymentWeight=43 orderStatusWeight=4 deliveryWeight=4 stockLevelWeight=4 // Directory name to crwww.walajiao.comeate for collecting detailed result data. // Comment this out to suppress. resultDirectory=my_result_%tY-%tm-%td_%tH%tM%tS osCollectorScript=./misc/os_collector_linux.py osCollectorInterval=1 //osCollectorSSHAddr=userdbhost // osCollectOrdDevices =net_eth0 blk_sda

LoadWorkers: test parallelism when data is loaded warehouses: number of warehouses, default 1, import 9 tables data size is 70M, when numWarehouse=10, size is close to 1GB Terminals: RuntxnsperTerminal: The number of transactions committed by each game agent terminal. This parameter and runMins can only select one runMins: specify the run time, in minutes limitTxnsPerMin: TerminalWareHouseFixed: Used to specify the binding mode between the terminal and the warehouse. True runs at all times in 4.x compatible mode, meaning that each terminal has a fixed warehouse. Set to false to evenly use the overall database configuration. The TPCC specifies that each terminal must have a repository of bindings, So generally use the default value of true copies – drive [oraclemyasm oracle] $cp/u02 / app/oracle/product / 11.2.0 / db_home/JDBC/lib/ojdbc6 jar. [oraclemyasm Oracle]$PWD /soft/ TPCC /benchmarksql-5.0/lib/oracle [Oracle Oracle]$ls readme.txt ojdbc6.jar [Oracle Oracle]$ Exec dbms_workload_repository.create_snapshot(); exec dbms_workload_repository.create_snapshot(); ./runBenchmark.sh props.ora