tpcc测试步骤

tpcc测试文档

1：上传软件并解压

扩容：
alter database resize logfile ‘/dm8/data/DAMENG/DAMENG01.log’ to 2048;
alter database resize logfile ‘/dm8/data/DAMENG/DAMENG02.log’ to 2048;
alter database add logfile ‘/dm8/data/DAMENG/DAMENG03.log’ size 2048;
alter database add logfile ‘/dm8/data/DAMENG/DAMENG04.log’ size 2048;
2：执行sql工具建表

修改prod.dm参数

重启数据库

在管理工具执行sql语句

Sql语句为：
/*
DROP USER “BENCHMARKSQL” CASCADE;
DROP TABLESPACE BENCHMARKSQL1;
*/

CREATE TABLESPACE BENCHMARKSQL1 DATAFILE ‘BENCHMARKSQL1.dbf’ SIZE 10000;
CREATE USER “BENCHMARKSQL” IDENTIFIED BY “123456789” DEFAULT TABLESPACE “BENCHMARKSQL1”;
GRANT DBA TO BENCHMARKSQL;

alter tablespace “ROLL” resize datafile ‘ROLL.DBF’ to 10000;
alter database resize logfile ‘DAMENG01.log’ to 10000;
alter database resize logfile ‘DAMENG02.log’ to 10000;

create table BENCHMARKSQL.bmsql_config (
cfg_name varchar(30) cluster primary key,
cfg_value varchar(50)
);

create table BENCHMARKSQL.bmsql_warehouse (
w_id integer not null,
w_ytd float,
w_tax float,
w_name varchar(10),
w_street_1 varchar(20),
w_street_2 varchar(20),
w_city