CNDBA社区
在数据库运维中，有时需要经常查询一些重复的信息，这些命令也比较长，不好记。 所以使用python工具将这些命令打包成了一个工具。
Oracle 版本的Orz 工具参考如下博客：
Orz 工具 3.0.1 版本 更新说明
https://www.cndba.cn/dave/article/3561
如何使用Orz工具 快速定位 和 解决数据问题
https://www.cndba.cn/dave/article/2348
这里介绍的达梦数据库版本的drz。 目前仅打包一些基本功能，后续在不断完善。
下载地址：
也可以从CNDBA社区的QQ群下载。
1 Drz 工具部署
1.1 复制drz文件
将drz 和 drz.ini 复制到root用户的文件下，比如/root/drz。
注意这里为了后期一些功能的使用考虑，必须放在root用户下执行。
1.2 给drz 添加可执行的权限
chmod a+x drz
1.3 修改drz.ini 里对应配置文件值
[root@www.cndba.cn_1 drz]# cat drz.ini
[Drz]
DBUSERNAME = dmdba
SYSDBA_PWD = SYSDBA
DBTYPE = DaMeng
BTW:这里明文存储密码有点不妥，解决方法也很简单，在程序里弄个加解密的函数就可以了，不过懒得弄了。:)
1.4 将~/.bashrc中添加环境变量
export PATH=$PATH:/root/drz
然后就可以在任意位置执行了。
1.5 命令帮助查看
查看单个目录帮助：
[root@www.cndba.cn drz]# drz tstat help
*********************************************************************
DRZ Tools for DaMeng database.
Version 1.0.1 date: 2019.09.20
Copyright (c) 2019. David Dai. ALL RIGHTS RESERVED.
Email: ahdba@qq.com
WebSite: https://www.cndba.cn
QQ group: 62697850 | 62697716 | 104207940 | 63306533
62697977 | 142216823 | 283816689
*********************************************************************
命令格式：drz tstat user_name tab_name
命令说明：查看表的统计信息
eg:drz tstat SYSDBA CNDBA
查看所有命令帮助：
[root@www.cndba.cn drz]# drz help
2 使用示例
#查看DM表空间：
[root@www.cndba.cn_1 /]# drz tsfree
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
| TABLESPACE_NAME | TOTAL_SIZE(M) | FREE_SIZE(M) | USED_SIZE(M) | USED_RATE(%) |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
| SYSTEM | 21 | 15 | 5 | 23 |
| MAIN | 128 | 127 | 0 | 0 |
| TEMP | 10 | 9 | 0 | 0 |
| ROLL | 128 | 93 | 34 | 26 |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#查看活动会话：
[root@www.cndba.cn_1 /]# drz active
#查看空闲会话：
[root@www.cndba.cn_1 /]# drz idle
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
| SESS_ID | SESS_SEQ | TRX_ID | USER_NAME | CLNT_HOST | CLNT_IP | SQL_TEXT |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
| 140516901590104 | 54472 | 140737488556866 | SYSDBA | dm1 | 127.0.0.1 | select * from v$database; |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#kill 会话：
[root@www.cndba.cn_1 /]# drz killsess 140516901590104
#查看redo log：
[root@www.cndba.cn_1 /]# drz rlog
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
| GROUP_ID | FILE_ID | CUR_FILE | RLOG_SIZE | PATH |
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
| 2 | 0 | 0 | 256 | /dm/dmdbms/data/dw/dw01.log |
| 2 | 1 | | 256 | /dm/dmdbms/data/dw/dw02.log |
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#统计对象信息：
[root@www.cndba.cn_1 /]# drz schobjs
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
| SCHEMA | VIEW | PROC | STAB | UTAB | SYNOM | CONS | INDEX |
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
| SYS | 123 | 23 | 254 | 7 | 0 | 27 | 270 |
| SYSJOB | 3 | 0 | 0 | 11 | 0 | 13 | 13 |
| CTISYS | 0 | 0 | 1 | 0 | 0 | 1 | 1 |
| SYSSSO | 0 | 0 | 8 | 0 | 0 | 9 | 9 |
| SYSAUDITOR | 0 | 0 | 4 | 0 | 0 | 2 | 5 |
| SYSDBA | 0 | 17 | 0 | 3 | 1 | 0 | 4 |
+++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
#查看对象大小：
[root@www.cndba.cn_1 /]# drz size cndba sysdba
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
| SEGMENT_NAME | SEGMENT_TYPE | PARTITION_NAME | TABLESPACE_NAME | SIZE(M) |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
| CNDBA | TABLE | | MAIN | 0 |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[root@www.cndba.cn_1 /]#
#查看对象DDL：
[root@www.cndba.cn_2 drz]# drz getddl table cndba sysdba
*****************DDL SQL******************
CREATE TABLE "SYSDBA"."CNDBA"
(
"NAME" VARCHAR(128),
"ID" INT,
"SCHID" INT,
"TYPE$" VARCHAR(10),
"SUBTYPE$" VARCHAR(10),
"PID" INT,
"VERSION" INT,
"CRTDATE" DATETIME(6),
"INFO1" INT,
"INFO2" INT,
"INFO3" BIGINT,
"INFO4" BIGINT,
"INFO5" VARBINARY(128),
"INFO6" VARBINARY(2048),
"INFO7" BIGINT,
"INFO8" VARBINARY(1024),
"VALID" CHAR(1)) STORAGE(ON "MAIN", CLUSTERBTR) ;
#启用AWR报告：
[root@www.cndba.cn_2 drz]# drz enawr 1
#查看表的统计信息：
[root@www.cndba.cn_2 drz]# drz tstat sysdba cndba
NUM_ROWS LEAF_BLOCKS LEAF_USED_BLOCKS
-------------------- -------------------- --------------------
NULL NULL NULL
#收集表的统计信息：
[root@www.cndba.cn_2 drz]# drz gtabstat sysdba cndba 3 100
[root@www.cndba.cn_2 drz]# drz tstat sysdba cndba
NUM_ROWS LEAF_BLOCKS LEAF_USED_BLOCKS
-------------------- -------------------- --------------------
1274 32 20
#查看索引的统计信息：
[root@www.cndba.cn_2 drz]# drz istat sysdba idx_id
BLEVEL LEAF_BLOCKS DISTINCT_KEYS CLUSTERING_FACTOR NUM_ROWS SAMPLE_SIZE
----------- -------------------- -------------------- ----------------- -------------------- --------------------
1 16 1274 0 1274 1274
#收集索引的统计信息：
[root@www.cndba.cn_2 drz]# drz gidxstat sysdba idx_id 3 50
[root@www.cndba.cn_2 drz]# drz istat sysdba idx_id
BLEVEL LEAF_BLOCKS DISTINCT_KEYS CLUSTERING_FACTOR NUM_ROWS SAMPLE_SIZE
----------- -------------------- -------------------- ----------------- -------------------- --------------------
1 16 465 0 1274 465
#查看未提交的事物，查看阻塞会话：
[root@www.cndba.cn_2 drz]# drz uncommit
+++++++++++++++++++++++++++++++++++++++++
| TABLE_NAME | LMODE | BLOCKED | TRX_ID |
+++++++++++++++++++++++++++++++++++++++++
| CNDBA | IX | 0 | 206024 |
+++++++++++++++++++++++++++++++++++++++++
[root@www.cndba.cn_2 drz]#
#查看表分区信息：
[root@www.cndba.cn_2 drz]# drz tabpart dave sysdba
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
| TABLE_NAME | PARTITION_NAME | TABLESPACE_NAME | HIGH_VALUE |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
| DAVE | P_DEFAULT | MAIN | DEFAULT |
| DAVE | P1 | MAIN | '巢湖','合肥' |
| DAVE | P2 | MAIN | '安庆','怀宁','太湖' |
| DAVE | P3 | MAIN | '广州','深圳' |
++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
[root@www.cndba.cn_2 drz]#
#启动AWR
[root@www.cndba.cn_2 drz]# drz enawr 1
#创建AWR 快照：
[root@www.cndba.cn_2 drz]# drz css
[root@www.cndba.cn_2 drz]# drz css
#查看AWR 快照：
[root@www.cndba.cn_2 drz]# drz sss 10
+++++++++++++++++++++++++++++++++++++++++++++++++++
| SNAP_ID | INSTANCE_NUMBER | END_INTERVAL_TIME |
+++++++++++++++++++++++++++++++++++++++++++++++++++
| 2 | 1 | 2019-09-25 11:15:28 |
| 1 | 1 | 2019-09-25 11:15:26 |
+++++++++++++++++++++++++++++++++++++++++++++++++++
[root@www.cndba.cn_2 drz]#
#生成AWR 报告：
[root@www.cndba.cn_2 drz]# drz awr 1 2 /tmp dave.html
-rw-r--r-- 1 dmdba dinstall 155K Sep 25 11:15 /tmp/dave.html
[root@www.cndba.cn_2 drz]#
版权声明：本文为博主原创文章，未经博主允许不得转载。
