HammerDB

加油鸭啦啦啦啦

已于 2023-11-09 17:51:11 修改

阅读量91

点赞数

文章标签：数据库

于 2023-11-08 20:15:05 首次发布

HammerDB

TPC:查看数据库的处理性能

TPM 每分钟执行次数

临时表空间30G

undo 30G

redo 不添加

tpcctab 30G

造数 warehouse 100

虚拟用户 50

启动监听

BASH

lsnrctl start

启动数据库

BASH

sqlplus / as sysdba
startup

重启监听

BASH

lsnrctl stop
lsnrctl start

连接到数据库

BASH

sqlplus sys/123@ORCL as sysdba

监听无服务，连接不到数据库时

BASH

vim $ORACLE_HOME/network/admin/listener.ora
添加
SID_LIST_LISTENER =
(SID_LIST =
  (SID_DESC =
  (GLOBAL_DBNAME = orcl)     
  (SID_NAME = orcl)        
  )
)

查看临时表空间命令

SQL

SELECT tablespace_name, ROUND(SUM(bytes) / 1024 / 1024) AS size_mb
FROM dba_temp_files
GROUP BY tablespace_name;

修改临时表空间

SQL

alter tablespace temp add tempfile size 30g;

ALTER TABLESPACE temp ADD TEMPFILE '/u01/app/oracle/oradata/orcl/temp02.dbf' SIZE 30G;

SQL

col property_name for a30
col PROPERTY_VALUE for a20
col DESCRIPTION for a60
-----------------------------------##查看默认表空间
SELECT * FROM database_properties WHERE property_name='DEFAULT_TEMP_TABLESPACE';

修改undo表空间

SQL

ALTER TABLESPACE undotbs1 ADD DATAFILE '/u01/app/oracle/oradata/orcl/undotbs1.dbf' SIZE 30G;

创建HammerDB用户表空间 – tpcctab

SQL

create tablespace tpcctab datafile size 30G;

CREATE TABLESPACE tpcctab
DATAFILE '/u01/app/oracle/oradata/orcl/tpcctab1.dbf' SIZE 30G;

HammerDB安装

修改/etc/selinux/config

PLAINTEXT

vim /etc/selinux/config

SELINUX=disabled
# SELINUXTYPE= can take one of three values:
#     targeted - Targeted processes are protected,
#     minimum - Modification of targeted policy. Only selected processes are protected. 
#     mls - Multi Level Security protection.
SELINUXTYPE=targeted

重启虚拟机

使用oracle用户执行export DISPLAY=':1.0'

./HammerDB-3.1

VNC

下载vnc服务

BASH

yum -y install tigervnc*

启动vnc服务 在root用户下

BASH

vncserver

BASH

[root@localhost ~]$ vncserver

New 'localhost.localdomain:1 (oracle)' desktop is localhost.localdomain:1

Starting applications specified in /home/oracle/.vnc/xstartup
Log file is /home/oracle/.vnc/localhost.localdomain:1.log
此时已经开启了一个id为1的vnc进程

查看vnc服务

BASH