benchmarksql tpcc 测试

dongxujian

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ pwd
/home/oracle/BenchmarkSQL-2.3.3/run
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ sqlplus /nolog

SQL> create tablespace tpcctab datafile size 2G;

Tablespace created.

SQL> create user tpcc identified by tpcc
  2  default tablespace tpcctab;

User created.

SQL> grant connect to tpcc;

Grant succeeded.

SQL> grant create table to tpcc;

Grant succeeded.

SQL> grant resource to tpcc;

Grant succeeded.

SQL> exit
Disconnected from Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Real Application Clusters, Automatic Storage Management, OLAP,
Data Mining and Real Application Testing options
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ pwd
/home/oracle/BenchmarkSQL-2.3.3/run
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ ls -ltr
total 152
-rw-r--r-- 1 oracle oinstall       227 Nov 20 2010  sqlTableTruncates
-rw-r--r-- 1 oracle oinstall       263 Nov 20 2010  sqlTableDrops
-rw-r--r-- 1 oracle oinstall    2957 Nov 20 2010  sqlTableCreates
-rw-r--r-- 1 oracle oinstall    1510 Nov 20 2010  sqlTableCopies_DB2
-rw-r--r-- 1 oracle oinstall    1640 Nov 20 2010  sqlTableCopies
-rw-r--r-- 1 oracle oinstall       595 Nov 20 2010  sqlIndexDrops
-rw-r--r-- 1 oracle oinstall    2067 Nov 20 2010  sqlIndexCreates_DB2
-rw-r--r-- 1 oracle oinstall    1003 Nov 20 2010  sqlIndexCreates
-rwxr-xr-x 1 oracle oinstall       201 Nov 20 2010  runSQL.sh
-rw-r--r-- 1 oracle oinstall       202 Nov 20 2010  runSQL.bat
-rwxr-xr-x 1 oracle oinstall       178 Nov 20 2010  runBenchmark.sh
-rw-r--r-- 1 oracle oinstall       208 Nov 20 2010  runBenchmark.bat
drwxr-xr-x 2 oracle oinstall       256 Nov 20 2010  reports
-rw-r--r-- 1 oracle oinstall       104 Nov 20 2010  postgres.properties
-rw-r--r-- 1 oracle oinstall       106 Nov 20 2010  oracle.properties
-rwxr-xr-x 1 oracle oinstall       196 Nov 20 2010  loadData.sh
-rw-r--r-- 1 oracle oinstall       197 Nov 20 2010  loadData.bat
-rw-r--r-- 1 oracle oinstall       93 Nov 20 2010  enterprisedb.properties
-rw-r--r-- 1 oracle oinstall       106 Nov 20 2010  db2.properties
drwxr-xr-x 2 oracle oinstall       256 Nov 20 2010  csv
-rw-r--r-- 1 oracle oinstall       348 Nov 20 2010  sqlTableTruncates_DB2

oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ ls -ltr
total 152
-rw-r--r-- 1 oracle oinstall       227 Nov 20 2010  sqlTableTruncates
-rw-r--r-- 1 oracle oinstall       263 Nov 20 2010  sqlTableDrops
-rw-r--r-- 1 oracle oinstall    2957 Nov 20 2010  sqlTableCreates
-rw-r--r-- 1 oracle oinstall    1510 Nov 20 2010  sqlTableCopies_DB2
-rw-r--r-- 1 oracle oinstall    1640 Nov 20 2010  sqlTableCopies
-rw-r--r-- 1 oracle oinstall       595 Nov 20 2010  sqlIndexDrops
-rw-r--r-- 1 oracle oinstall    2067 Nov 20 2010  sqlIndexCreates_DB2
-rw-r--r-- 1 oracle oinstall    1003 Nov 20 2010  sqlIndexCreates
-rwxr-xr-x 1 oracle oinstall       201 Nov 20 2010  runSQL.sh
-rw-r--r-- 1 oracle oinstall       202 Nov 20 2010  runSQL.bat
-rwxr-xr-x 1 oracle oinstall       178 Nov 20 2010  runBenchmark.sh
-rw-r--r-- 1 oracle oinstall       208 Nov 20 2010  runBenchmark.bat
drwxr-xr-x 2 oracle oinstall       256 Nov 20 2010  reports
-rw-r--r-- 1 oracle oinstall       104 Nov 20 2010  postgres.properties
-rw-r--r-- 1 oracle oinstall       106 Nov 20 2010  oracle.properties
-rwxr-xr-x 1 oracle oinstall       196 Nov 20 2010  loadData.sh
-rw-r--r-- 1 oracle oinstall       197 Nov 20 2010  loadData.bat
-rw-r--r-- 1 oracle oinstall       93 Nov 20 2010  enterprisedb.properties
-rw-r--r-- 1 oracle oinstall       106 Nov 20 2010  db2.properties
drwxr-xr-x 2 oracle oinstall       256 Nov 20 2010  csv
-rw-r--r-- 1 oracle oinstall       348 Nov 20 2010  sqlTableTruncates_DB2
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ vi oracle.properties
driver=oracle.jdbc.driver.OracleDriver
conn=jdbc

racle:thin

localhost:1521:XE
user=scott
password=tiger
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
~
driver=oracle.jdbc.driver.OracleDriver
conn=jdbc

racle:thin

localhost:1521:XE
userscott
driver=oracle.jdbc.driver.OracleDriver
conn=jdbc

racle:thin

localhost:1521:XE
userscott

driver=oracle.jdbc.driver.OracleDriver
conn=jdbc

racle:thin

localhost:1521:XE
:q!
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ ls -ltr
total 152
-rw-r--r-- 1 oracle oinstall       227 Nov 20 2010  sqlTableTruncates
-rw-r--r-- 1 oracle oinstall       263 Nov 20 2010  sqlTableDrops
-rw-r--r-- 1 oracle oinstall    2957 Nov 20 2010  sqlTableCreates
-rw-r--r-- 1 oracle oinstall    1510 Nov 20 2010  sqlTableCopies_DB2
-rw-r--r-- 1 oracle oinstall    1640 Nov 20 2010  sqlTableCopies
-rw-r--r-- 1 oracle oinstall       595 Nov 20 2010  sqlIndexDrops
-rw-r--r-- 1 oracle oinstall    2067 Nov 20 2010  sqlIndexCreates_DB2
-rw-r--r-- 1 oracle oinstall    1003 Nov 20 2010  sqlIndexCreates
-rwxr-xr-x 1 oracle oinstall       201 Nov 20 2010  runSQL.sh
-rw-r--r-- 1 oracle oinstall       202 Nov 20 2010  runSQL.bat
-rwxr-xr-x 1 oracle oinstall       178 Nov 20 2010  runBenchmark.sh
-rw-r--r-- 1 oracle oinstall       208 Nov 20 2010  runBenchmark.bat
drwxr-xr-x 2 oracle oinstall       256 Nov 20 2010  reports
-rw-r--r-- 1 oracle oinstall       104 Nov 20 2010  postgres.properties
-rw-r--r-- 1 oracle oinstall       106 Nov 20 2010  oracle.properties
-rwxr-xr-x 1 oracle oinstall       196 Nov 20 2010  loadData.sh
-rw-r--r-- 1 oracle oinstall       197 Nov 20 2010  loadData.bat
-rw-r--r-- 1 oracle oinstall       93 Nov 20 2010  enterprisedb.properties
-rw-r--r-- 1 oracle oinstall       106 Nov 20 2010  db2.properties
drwxr-xr-x 2 oracle oinstall       256 Nov 20 2010  csv
-rw-r--r-- 1 oracle oinstall       348 Nov 20 2010  sqlTableTruncates_DB2
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ vi oracle.properties

driver=oracle.jdbc.driver.OracleDriver
conn=jdbc

racle:thin

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=p750pr-scan)(PORT=1521))(LOAD_BALANCE=YES)(FAILOVER=YES)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))
user=tpcc
"oracle.properties" 4 lines, 238 characters
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ ls -ltr
total 152
-rw-r--r-- 1 oracle oinstall       227 Nov 20 2010  sqlTableTruncates
-rw-r--r-- 1 oracle oinstall       263 Nov 20 2010  sqlTableDrops
-rw-r--r-- 1 oracle oinstall    2957 Nov 20 2010  sqlTableCreates
-rw-r--r-- 1 oracle oinstall    1510 Nov 20 2010  sqlTableCopies_DB2
-rw-r--r-- 1 oracle oinstall    1640 Nov 20 2010  sqlTableCopies
-rw-r--r-- 1 oracle oinstall       595 Nov 20 2010  sqlIndexDrops
-rw-r--r-- 1 oracle oinstall    2067 Nov 20 2010  sqlIndexCreates_DB2
-rw-r--r-- 1 oracle oinstall    1003 Nov 20 2010  sqlIndexCreates
-rwxr-xr-x 1 oracle oinstall       201 Nov 20 2010  runSQL.sh
-rw-r--r-- 1 oracle oinstall       202 Nov 20 2010  runSQL.bat
-rwxr-xr-x 1 oracle oinstall       178 Nov 20 2010  runBenchmark.sh
-rw-r--r-- 1 oracle oinstall       208 Nov 20 2010  runBenchmark.bat
drwxr-xr-x 2 oracle oinstall       256 Nov 20 2010  reports
-rw-r--r-- 1 oracle oinstall       104 Nov 20 2010  postgres.properties
-rwxr-xr-x 1 oracle oinstall       196 Nov 20 2010  loadData.sh
-rw-r--r-- 1 oracle oinstall       197 Nov 20 2010  loadData.bat
-rw-r--r-- 1 oracle oinstall       93 Nov 20 2010  enterprisedb.properties
-rw-r--r-- 1 oracle oinstall       106 Nov 20 2010  db2.properties
drwxr-xr-x 2 oracle oinstall       256 Nov 20 2010  csv
-rw-r--r-- 1 oracle oinstall       348 Nov 20 2010  sqlTableTruncates_DB2
-rw-r--r-- 1 oracle oinstall       238 Jan 06 15:02 oracle.properties

创建测试表：

oracle@p750pr1:/usr/java8_64/jre/bin$ export JAVA_HOME=/usr/java8_64/jre/

oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ echo $JAVA_HOME
/usr/java8_64/jre/
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ ./runSQL.sh oracle.properties sqlTableCreates
------------- ExecJDBC Start Date = Wed Jan 06 15:08:20 CST 2016-------------
driver=oracle.jdbc.driver.OracleDriver
conn=jdbc

racle:thin

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=p750pr-scan)(PORT=1521))(LOAD_BALANCE=YES)(FAILOVER=YES)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))
user=tpcc
password=******
commandFile=sqlTableCreates
-------------------------------------------------

create table warehouse (
w_id       integer not null,
w_ytd    decimal(12,2),
w_tax    decimal(4,4),
w_name    varchar(10),
w_street_1  varchar(20),
w_street_2  varchar(20),
w_city    varchar(20),
w_state    char(2),
w_zip    char(9)
);
-- SQL Success: Runtime = 266 ms --

commit;
-- SQL Success: Runtime = 1 ms --

create table district (
d_w_id    integer    not null,
d_id       integer    not null,
d_ytd       decimal(12,2),
d_tax       decimal(4,4),
d_next_o_id  integer,
d_name    varchar(10),
d_street_1 varchar(20),
d_street_2 varchar(20),
d_city    varchar(20),
d_state    char(2),
d_zip       char(9)
);
-- SQL Success: Runtime = 71 ms --

commit;
-- SQL Success: Runtime = 1 ms --

create table customer (
c_w_id       integer       not null,
c_d_id       integer       not null,
c_id          integer       not null,
c_discount    decimal(4,4),
c_credit    char(2),
c_last       varchar(16),
c_first       varchar(16),
c_credit_lim decimal(12,2),
c_balance    decimal(12,2),
c_ytd_payment  float,
c_payment_cnt  integer,
c_delivery_cnt integer,
c_street_1    varchar(20),
c_street_2    varchar(20),
c_city       varchar(20),
c_state       char(2),
c_zip       char(9),
c_phone       char(16),
c_since       timestamp,
c_middle    char(2),
c_data       varchar(500)
);
-- SQL Success: Runtime = 44 ms --

commit;
-- SQL Success: Runtime = 2 ms --

create table history (
h_c_id integer,
h_c_d_id integer,
h_c_w_id integer,
h_d_id integer,
h_w_id integer,
h_date timestamp,
h_amount decimal(6,2),
h_data varchar(24)
);
-- SQL Success: Runtime = 31 ms --

commit;
-- SQL Success: Runtime = 1 ms --

create table oorder (
o_w_id    integer    not null,
o_d_id    integer    not null,
o_id       integer    not null,
o_c_id    integer,
o_carrier_id integer,
o_ol_cnt    decimal(2,0),
o_all_local  decimal(1,0),
o_entry_d timestamp
);
-- SQL Success: Runtime = 44 ms --

commit;
-- SQL Success: Runtime = 2 ms --

create table new_order (
no_w_id  integer not null,
no_d_id  integer not null,
no_o_id  integer not null
);
-- SQL Success: Runtime = 37 ms --

commit;
-- SQL Success: Runtime = 2 ms --

create table order_line (
ol_w_id       integer not null,
ol_d_id       integer not null,
ol_o_id       integer not null,
ol_number    integer not null,
ol_i_id       integer not null,
ol_delivery_d timestamp,
ol_amount    decimal(6,2),
ol_supply_w_id  integer,
ol_quantity    decimal(2,0),
ol_dist_info char(24)
);
-- SQL Success: Runtime = 41 ms --

commit;
-- SQL Success: Runtime = 2 ms --

create table stock (
s_w_id    integer    not null,
s_i_id    integer    not null,
s_quantity decimal(4,0),
s_ytd       decimal(8,2),
s_order_cnt  integer,
s_remote_cnt integer,
s_data    varchar(50),
s_dist_01 char(24),
s_dist_02 char(24),
s_dist_03 char(24),
s_dist_04 char(24),
s_dist_05 char(24),
s_dist_06 char(24),
s_dist_07 char(24),
s_dist_08 char(24),
s_dist_09 char(24),
s_dist_10 char(24)
);
-- SQL Success: Runtime = 41 ms --

commit;
-- SQL Success: Runtime = 2 ms --

create table item (
i_id    integer    not null,
i_name varchar(24),
i_price  decimal(5,2),
i_data varchar(50),
i_im_id  integer
);
-- SQL Success: Runtime = 37 ms --

commit;
-- SQL Success: Runtime = 2 ms --

------------- ExecJDBC End Date = Wed Jan 06 15:08:21 CST 2016-------------
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ ls -ltr
total 152
-rw-r--r-- 1 oracle oinstall       227 Nov 20 2010  sqlTableTruncates
-rw-r--r-- 1 oracle oinstall       263 Nov 20 2010  sqlTableDrops
-rw-r--r-- 1 oracle oinstall    2957 Nov 20 2010  sqlTableCreates
-rw-r--r-- 1 oracle oinstall    1510 Nov 20 2010  sqlTableCopies_DB2
-rw-r--r-- 1 oracle oinstall    1640 Nov 20 2010  sqlTableCopies
-rw-r--r-- 1 oracle oinstall       595 Nov 20 2010  sqlIndexDrops
-rw-r--r-- 1 oracle oinstall    2067 Nov 20 2010  sqlIndexCreates_DB2
-rw-r--r-- 1 oracle oinstall    1003 Nov 20 2010  sqlIndexCreates
-rwxr-xr-x 1 oracle oinstall       201 Nov 20 2010  runSQL.sh
-rw-r--r-- 1 oracle oinstall       202 Nov 20 2010  runSQL.bat
-rwxr-xr-x 1 oracle oinstall       178 Nov 20 2010  runBenchmark.sh
-rw-r--r-- 1 oracle oinstall       208 Nov 20 2010  runBenchmark.bat
drwxr-xr-x 2 oracle oinstall       256 Nov 20 2010  reports
-rw-r--r-- 1 oracle oinstall       104 Nov 20 2010  postgres.properties
-rwxr-xr-x 1 oracle oinstall       196 Nov 20 2010  loadData.sh
-rw-r--r-- 1 oracle oinstall       197 Nov 20 2010  loadData.bat
-rw-r--r-- 1 oracle oinstall       93 Nov 20 2010  enterprisedb.properties
-rw-r--r-- 1 oracle oinstall       106 Nov 20 2010  db2.properties
drwxr-xr-x 2 oracle oinstall       256 Nov 20 2010  csv
-rw-r--r-- 1 oracle oinstall       348 Nov 20 2010  sqlTableTruncates_DB2
-rw-r--r-- 1 oracle oinstall       238 Jan 06 15:02 oracle.properties
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ echo $JAVA_HOME
/usr/java8_64/jre/
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ ./loadData.sh oracle.properties numWarehouses 10
----------------- Initialization -------------------
numWarehouses
Setting the number of warehouses to: 10
10
driver=oracle.jdbc.driver.OracleDriver
conn=jdbc

racle:thin

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=p750pr-scan)(PORT=1521))(LOAD_BALANCE=YES)(FAILOVER=YES)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))
user=tpcc
password=******
Truncating 'item' ...
Truncating 'warehouse' ...
Truncating 'stock' ...
Truncating 'district' ...
Truncating 'customer' ...
Truncating 'history' ...
Truncating 'oorder' ...
Truncating 'order_line' ...
Truncating 'new_order' ...
------------- LoadData Start Date = Wed Jan 06 15:09:44 CST 2016-------------

Start Whse Load for 10 Whses @ Wed Jan 06 15:09:44 CST 2016 ...
Elasped Time(ms): 0.063
End Whse Load @  Wed Jan 06 15:09:44 CST 2016

Start Item Load for 100000 Items @ Wed Jan 06 15:09:44 CST 2016 ...

  Elasped Time(ms): 0.024    Writing final records 1000000 of 1000000
End Stock Load @  Wed Jan 06 15:12:17 CST 2016

Start District Data for 100 Dists @ Wed Jan 06 15:12:17 CST 2016 ...
  Elasped Time(ms): 0.057    Writing record 100 of 100
End District Load @  Wed Jan 06 15:12:17 CST 2016

Start Cust-Hist Load for 600000 Cust-Hists @ Wed Jan 06 15:12:17 CST 2016 ...
  E
End Cust-Hist Data Load @  Wed Jan 06 15:14:50 CST 2016
whse=10, dist=10, cust=3000

Start Order-Line-New Load for approx 3400000 rows @ Wed Jan 06 15:14:50 CST 2016 ...
  Elasped Time(ms): 0.013    Writing record 1000 of 3400000

  Writing final records 3388848 of 3400000
End Orders Load @  Wed Jan 06 15:15:47 CST 2016

------------- LoadJDBC Statistics --------------------
   Start Time = Wed Jan 06 15:09:44 CST 2016
   End Time = Wed Jan 06 15:15:47 CST 2016
   Run Time = 362 Seconds
Rows Loaded = 5088958 Rows
Rows Per Second = 14057 Rows/Sec
------------------------------------------------------
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$

创建相关索引：
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ ./runSQL.sh oracle.properties sqlIndexCreates
------------- ExecJDBC Start Date = Wed Jan 06 15:16:42 CST 2016-------------
driver=oracle.jdbc.driver.OracleDriver
conn=jdbc

racle:thin

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=p750pr-scan)(PORT=1521))(LOAD_BALANCE=YES)(FAILOVER=YES)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))
user=tpcc
password=******
commandFile=sqlIndexCreates
-------------------------------------------------

alter table warehouse add constraint pk_warehouse
primary key (w_id);
-- SQL Success: Runtime = 182 ms --

commit;
-- SQL Success: Runtime = 1 ms --

alter table district add constraint pk_district
primary key (d_w_id, d_id);
-- SQL Success: Runtime = 64 ms --

commit;
-- SQL Success: Runtime = 1 ms --

alter table customer add constraint pk_customer
primary key (c_w_id, c_d_id, c_id);
-- SQL Success: Runtime = 856 ms --

commit;
-- SQL Success: Runtime = 2 ms --

create index ndx_customer_name
on customer (c_w_id, c_d_id, c_last, c_first);
-- SQL Success: Runtime = 1023 ms --

commit;
-- SQL Success: Runtime = 1 ms --

-- history table has no primary key
-- commit;

alter table oorder add constraint pk_oorder
primary key (o_w_id, o_d_id, o_id);
-- SQL Success: Runtime = 587 ms --

commit;
-- SQL Success: Runtime = 2 ms --

create unique index ndx_oorder_carrier
on oorder (o_w_id, o_d_id, o_carrier_id, o_id);
-- SQL Success: Runtime = 628 ms --

commit;
-- SQL Success: Runtime = 2 ms --

alter table new_order add constraint pk_new_order
primary key (no_w_id, no_d_id, no_o_id);
-- SQL Success: Runtime = 219 ms --

commit;
-- SQL Success: Runtime = 2 ms --

alter table order_line add constraint pk_order_line
primary key (ol_w_id, ol_d_id, ol_o_id, ol_number);
-- SQL Success: Runtime = 6736 ms --

commit;
-- SQL Success: Runtime = 2 ms --

alter table stock add constraint pk_stock
primary key (s_w_id, s_i_id);
-- SQL Success: Runtime = 2336 ms --

commit;
-- SQL Success: Runtime = 1 ms --

alter table item add constraint pk_item
primary key (i_id);
-- SQL Success: Runtime = 210 ms --

commit;
-- SQL Success: Runtime = 2 ms --

vacuum analyze;
-- SQL Runtime Exception -----------------------------------------
DBMS SqlCode=900 DBMS Msg=
ORA-00900: invalid SQL statement

------------------------------------------------------------------

------------- ExecJDBC End Date = Wed Jan 06 15:16:55 CST 2016-------------
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
执行测试：
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ export DISPLAY=10.91.168.112:0.0
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ xhost +
access control disabled, clients can connect from any host
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ ./runBenchmark.sh oracle.properties
driver=oracle.jdbc.driver.OracleDriver
conn=jdbc

racle:thin

(DESCRIPTION=(ADDRESS=(PROTOCOL=TCP)(HOST=p750pr-scan)(PORT=1521))(LOAD_BALANCE=YES)(FAILOVER=YES)(CONNECT_DATA=(SERVER=DEDICATED)(SERVICE_NAME=orcl)))
user=tpcc
password=******
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ ls -ltr
total 152
-rw-r--r-- 1 oracle oinstall       227 Nov 20 2010  sqlTableTruncates
-rw-r--r-- 1 oracle oinstall       263 Nov 20 2010  sqlTableDrops
-rw-r--r-- 1 oracle oinstall    2957 Nov 20 2010  sqlTableCreates
-rw-r--r-- 1 oracle oinstall    1510 Nov 20 2010  sqlTableCopies_DB2
-rw-r--r-- 1 oracle oinstall    1640 Nov 20 2010  sqlTableCopies
-rw-r--r-- 1 oracle oinstall       595 Nov 20 2010  sqlIndexDrops
-rw-r--r-- 1 oracle oinstall    2067 Nov 20 2010  sqlIndexCreates_DB2
-rw-r--r-- 1 oracle oinstall    1003 Nov 20 2010  sqlIndexCreates
-rwxr-xr-x 1 oracle oinstall       201 Nov 20 2010  runSQL.sh
-rw-r--r-- 1 oracle oinstall       202 Nov 20 2010  runSQL.bat
-rwxr-xr-x 1 oracle oinstall       178 Nov 20 2010  runBenchmark.sh
-rw-r--r-- 1 oracle oinstall       208 Nov 20 2010  runBenchmark.bat
-rw-r--r-- 1 oracle oinstall       104 Nov 20 2010  postgres.properties
-rwxr-xr-x 1 oracle oinstall       196 Nov 20 2010  loadData.sh
-rw-r--r-- 1 oracle oinstall       197 Nov 20 2010  loadData.bat
-rw-r--r-- 1 oracle oinstall       93 Nov 20 2010  enterprisedb.properties
-rw-r--r-- 1 oracle oinstall       106 Nov 20 2010  db2.properties
drwxr-xr-x 2 oracle oinstall       256 Nov 20 2010  csv
-rw-r--r-- 1 oracle oinstall       348 Nov 20 2010  sqlTableTruncates_DB2
-rw-r--r-- 1 oracle oinstall       238 Jan 06 15:02 oracle.properties
drwxr-xr-x 2 oracle oinstall       256 Jan 06 15:52 reports
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run$ cd csv
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run/csv$ ls
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run/csv$ cd ../reports
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run/reports$ ls
BenchmarkSQL_session_20060104220209.txt  BenchmarkSQL_session_20160106155225.txt
BenchmarkSQL_session_20160106152019.txt
oracle@p750pr1:/home/oracle/BenchmarkSQL-2.3.3/run/reports$ mv BenchmarkSQL_session_20160106152019.txt /home/oracle/

图文精华

benchmarksql tpcc 测试