[Oracle Database] Database performance testing tool: BenchmarkSQL

[oracle@king01] $sqlplus / as sysdbaSQL > create tablespace tpccdatafile'/ u01/app/oracle/oradata/king/tpcc01.dbf'size 1024Mextent management localuniform size 1m Tablespace created.SQL > create user tpcc identified by tpcc default tablespace tpcc;User created.SQL > grant connect,resource to tpcc Grant succeeded. [root@king02 ~] # yum install-y ant [root@king02 ~] # unzip benchmarksql-5.0.zip [root@king02 ~] # cd benchmarksql-5.0 [root@king02 benchmarksql-5.0] # antBuildfile: build.xmlinit: [mkdir] Created dir: / root/benchmarksql-5.0/buildcompile: [javac] Compiling 11 source files to / root/benchmarksql-5.0/build [javac] This version of java does not support the classic compiler Upgrading to moderndist: [mkdir] Created dir: / root/benchmarksql-5.0/dist [jar] Building jar: / root/benchmarksql-5.0/dist/BenchmarkSQL-5.0.jarBUILD SUCCESSFULTotal time: 3 seconds [root@king02 benchmarksql-5.0] # cd run [root@king02 run] # vi props.oradb=oracledriver=oracle.jdbc.driver.OracleDriverconn=jdbc:oracle:thin:@192.168.1.201:1521:kinguser=tpccpassword=tpccwarehouses=10loadWorkers=5terminals=10//To run specified transactions per terminal- runMins must equal zerorunTxnsPerTerminal=1000//To run For specified minutes- runTxnsPerTerminal must equal zerorunMins=0//Number of total transactions per minutelimitTxnsPerMin=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 100newOrderWeight=45paymentWeight=43orderStatusWeight=4deliveryWeight=4stockLevelWeight=4 [root@king02 run] #. / runDatabaseBuild.sh props.ora [root@king02 run] #. / runBenchmark.sh props.ora21:45:16311 [main] INFO jTPCC: Term-00, 21:45:16326 [main] INFO jTPCC: Term-00 +-- + 21 main 45 main 16 326 [main] INFO jTPCC: Term-00, BenchmarkSQL v5.021 15 15 15 [main] INFO jTPCC: Term-00 +-- + 21 main 4515 INFO jTPCC: Term-00, (c) 2003, Raul Barbosa21:45:16326 [main] INFO jTPCC: Term-00, (c) 2004-2016, Denis Lussier21:45:16336 [main] INFO jTPCC: Term-00, (c) 2016 Jan Wieck21:45:16337 [main] INFO jTPCC: Term-00, +-- + 21 main 45 main [main] INFO jTPCC: Term-00, 21 INFO jTPCC 45 Jan Wieck21:45:16337 [main] INFO jTPCC: Term-00, db=oracle21:45:16337 [main] INFO jTPCC: Term-00 Driver=oracle.jdbc.driver.OracleDriver21:45:16337 [main] INFO jTPCC: Term-00, conn=jdbc:oracle:thin:@192.168.1.201:1521:king21:45:16337 [main] INFO jTPCC: Term-00, user=tpcc21:45:16338 [main] INFO jTPCC: Term-00, 21:45:16338 [main] INFO jTPCC: Term-00, warehouses=1021:45:16338 [main] INFO jTPCC: Term-00, terminals=1021:45:16345 [main] INFO jTPCC: Term-00 RunTxnsPerTerminal=100021:45:16345 [main] INFO jTPCC: Term-00, limitTxnsPerMin=30021:45:16348 [main] INFO jTPCC: Term-00, terminalWarehouseFixed=true21:45:16349 [main] INFO jTPCC: Term-00, 21:45:16349 [main] INFO jTPCC: Term-00, newOrderWeight=4521:45:16349 [main] INFO jTPCC: Term-00, paymentWeight=4321:45:16349 [main] INFO jTPCC: Term-00, orderStatusWeight=421:45:16349 [main] INFO jTPCC: Term-00, deliveryWeight=421:45:16349 [main] INFO jTPCC: Term-00 StockLevelWeight=421:45:16349 [main] INFO jTPCC: Term-00, 21:45:16353 [main] INFO jTPCC: Term-00, resultDirectory=null21:45:16353 [main] INFO jTPCC: Term-00, osCollectorScript=null21:45:16353 [main] INFO jTPCC: Term-00, 21:45:18823 [main] INFO jTPCC: Term-00, C value for C_LAST during load: 23121:45:18823 [main] INFO jTPCC: Term-00, C value for C_LAST this run: 13321:45:18824 [main] INFO jTPCC: Term-00 Term-00, Running Average tpmTOTAL: 294.45 Current tpmTOTAL: 26748 Memory Usage: 23MB / 57MB Term-00, Running Average tpmTOTAL: 296.45 Current tpmTOTAL: 65652 Memory Usage: 21MB / 57MB 22:19:06361 [Thread-9] INFO jTPCC: Term-00, 22:19:06361 [Thread-9] INFO jTPCC: Term-00, 22:19:06362 [Thread-9] INFO jTPCC: Term-00 Measured tpmC (NewOrders) = 134.1722 19INFO jTPCC 06362 [Thread-9] INFO jTPCC: Term-00, Measured tpmTOTAL = 296.1622 19buret 06363 [Thread-9] INFO jTPCC: Term-00, Session Start = 2019-05-25 21 Vera 4522 Vol 2022 19Thread-9 INFO jTPCC: Term-00 Session End = 2019-05-25 22:19:06 [root@king02 run] # / runDatabaseDestroy.sh props.ora#-- # Loading SQL file. / sql.common/tableDrops.sql#- -drop table bmsql_config Drop table bmsql_new_order;drop table bmsql_order_line;drop table bmsql_oorder;drop table bmsql_history;drop table bmsql_customer;drop table bmsql_stock;drop table bmsql_item;drop table bmsql_district;drop table bmsql_warehouse;drop sequence bmsql_hist_id_seq