亚洲激情专区-91九色丨porny丨老师-久久久久久久女国产乱让韩-国产精品午夜小视频观看

溫馨提示×

溫馨提示×

您好,登錄后才能下訂單哦!

密碼登錄×
登錄注冊×
其他方式登錄
點擊 登錄注冊 即表示同意《億速云用戶服務條款》

【Oracle Database】數據庫性能測試工具:BenchmarkSQL

發布時間:2020-07-07 17:41:46 來源:網絡 閱讀:1107 作者:NOGYMS 欄目:關系型數據庫
[oracle@king01?~]$?sqlplus?/?as?sysdba
SQL>?create?tablespace?tpcc
datafile?'/u01/app/oracle/oradata/king/tpcc01.dbf'
size?1024M
extent?management?local
uniform?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]#?ant
Buildfile:?build.xml

init:
????[mkdir]?Created?dir:?/root/benchmarksql-5.0/build

compile:
????[javac]?Compiling?11?source?files?to?/root/benchmarksql-5.0/build
????[javac]?This?version?of?java?does?not?support?the?classic?compiler;?upgrading?to?modern

dist:
????[mkdir]?Created?dir:?/root/benchmarksql-5.0/dist
??????[jar]?Building?jar:?/root/benchmarksql-5.0/dist/BenchmarkSQL-5.0.jar

BUILD?SUCCESSFUL
Total?time:?3?seconds

[root@king02?benchmarksql-5.0]#?cd?run
[root@king02?run]#?vi?props.ora
db=oracle
driver=oracle.jdbc.driver.OracleDriver
conn=jdbc:oracle:thin:@192.168.1.201:1521:king
user=tpcc
password=tpcc

warehouses=10
loadWorkers=5

terminals=10
//To?run?specified?transactions?per?terminal-?runMins?must?equal?zero
runTxnsPerTerminal=1000
//To?run?for?specified?minutes-?runTxnsPerTerminal?must?equal?zero
runMins=0
//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

[root@king02?run]#?./runDatabaseBuild.sh?props.ora

[root@king02?run]#?./runBenchmark.sh?props.ora
21:45:16,311?[main]?INFO???jTPCC?:?Term-00,?
21:45:16,326?[main]?INFO???jTPCC?:?Term-00,?+-------------------------------------------------------------+
21:45:16,326?[main]?INFO???jTPCC?:?Term-00,??????BenchmarkSQL?v5.0
21:45:16,326?[main]?INFO???jTPCC?:?Term-00,?+-------------------------------------------------------------+
21:45:16,326?[main]?INFO???jTPCC?:?Term-00,??(c)?2003,?Raul?Barbosa
21:45:16,326?[main]?INFO???jTPCC?:?Term-00,??(c)?2004-2016,?Denis?Lussier
21:45:16,336?[main]?INFO???jTPCC?:?Term-00,??(c)?2016,?Jan?Wieck
21:45:16,337?[main]?INFO???jTPCC?:?Term-00,?+-------------------------------------------------------------+
21:45:16,337?[main]?INFO???jTPCC?:?Term-00,?
21:45:16,337?[main]?INFO???jTPCC?:?Term-00,?db=oracle
21:45:16,337?[main]?INFO???jTPCC?:?Term-00,?driver=oracle.jdbc.driver.OracleDriver
21:45:16,337?[main]?INFO???jTPCC?:?Term-00,?conn=jdbc:oracle:thin:@192.168.1.201:1521:king
21:45:16,337?[main]?INFO???jTPCC?:?Term-00,?user=tpcc
21:45:16,338?[main]?INFO???jTPCC?:?Term-00,?
21:45:16,338?[main]?INFO???jTPCC?:?Term-00,?warehouses=10
21:45:16,338?[main]?INFO???jTPCC?:?Term-00,?terminals=10
21:45:16,345?[main]?INFO???jTPCC?:?Term-00,?runTxnsPerTerminal=1000
21:45:16,345?[main]?INFO???jTPCC?:?Term-00,?limitTxnsPerMin=300
21:45:16,348?[main]?INFO???jTPCC?:?Term-00,?terminalWarehouseFixed=true
21:45:16,349?[main]?INFO???jTPCC?:?Term-00,?
21:45:16,349?[main]?INFO???jTPCC?:?Term-00,?newOrderWeight=45
21:45:16,349?[main]?INFO???jTPCC?:?Term-00,?paymentWeight=43
21:45:16,349?[main]?INFO???jTPCC?:?Term-00,?orderStatusWeight=4
21:45:16,349?[main]?INFO???jTPCC?:?Term-00,?deliveryWeight=4
21:45:16,349?[main]?INFO???jTPCC?:?Term-00,?stockLevelWeight=4
21:45:16,349?[main]?INFO???jTPCC?:?Term-00,?
21:45:16,353?[main]?INFO???jTPCC?:?Term-00,?resultDirectory=null
21:45:16,353?[main]?INFO???jTPCC?:?Term-00,?osCollectorScript=null
21:45:16,353?[main]?INFO???jTPCC?:?Term-00,?
21:45:18,823?[main]?INFO???jTPCC?:?Term-00,?C?value?for?C_LAST?during?load:?231
21:45:18,823?[main]?INFO???jTPCC?:?Term-00,?C?value?for?C_LAST?this?run:????133
21:45:18,824?[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:06,361?[Thread-9]?INFO???jTPCC?:?Term-00,?
22:19:06,361?[Thread-9]?INFO???jTPCC?:?Term-00,?
22:19:06,362?[Thread-9]?INFO???jTPCC?:?Term-00,?Measured?tpmC?(NewOrders)?=?134.17
22:19:06,362?[Thread-9]?INFO???jTPCC?:?Term-00,?Measured?tpmTOTAL?=?296.16
22:19:06,363?[Thread-9]?INFO???jTPCC?:?Term-00,?Session?Start?????=?2019-05-25?21:45:20
22:19:06,363?[Thread-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;


向AI問一下細節

免責聲明:本站發布的內容(圖片、視頻和文字)以原創、轉載和分享為主,文章觀點不代表本網站立場,如果涉及侵權請聯系站長郵箱:is@yisu.com進行舉報,并提供相關證據,一經查實,將立刻刪除涉嫌侵權內容。

AI

宁陕县| 将乐县| 永川市| 黄大仙区| 凤凰县| 临颍县| 苏尼特右旗| 金湖县| 承德市| 华宁县| 青田县| 宜州市| 丰台区| 洛阳市| 龙州县| 石景山区| 兖州市| 忻州市| 赤壁市| 册亨县| 天镇县| 蛟河市| 安徽省| 漳州市| 分宜县| 普兰店市| 大安市| 桦川县| 虹口区| 南投县| 壤塘县| 和平县| 绥芬河市| 任丘市| 江川县| 湖州市| 古浪县| 谢通门县| 永泰县| 米泉市| 枣阳市|