重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛

标题: 分析oracle系统 trace文件及dump文件的工具 ass109.awk [打印本页]

作者: 郑全 时间: 2014-11-6 14:42
标题: 分析oracle系统 trace文件及dump文件的工具 ass109.awk

ass109.awk工具，用于分析trace文件

使用方法很简单：
awk -f ass109.awk (trace | dump file)

下面是我在本机环境下(Linux+ Oracle RDBMS 11.2.0.1)进行的操作
首先用ORADEBUG工具DUMP出系统状态，这里只看使用方法即可。
sys@LUOCS11G> oradebug setmypid
Statement processed.
sys@LUOCS11G> oradebug unlimit;
Statement processed.
sys@LUOCS11G> oradebug dump systemstate 10;
Statement processed.
sys@LUOCS11G> oradebug tracefile_name
/u01/app/oracle/diag/rdbms/luocs11g/luocs11g/trace/luocs11g_ora_32420.trc

然后使用ASS工具。
[oracle@localhost ~]$ awk -f ass109.awk /u01/app/oracle/diag/rdbms/luocs11g/luocs11g/trace/luocs11g_ora_32420.trc

Starting Systemstate 1
....................................
Ass.Awk Version 1.0.9 - Processing /u01/app/oracle/diag/rdbms/luocs11g/luocs11g/trace/luocs11g_ora_32420.trc

System State 1
~~~~~~~~~~~~~~~~
1:
2: 0: waiting for 'pmon timer'
3: 0: waiting for 'VKTM Logical Idle Wait'
4: 0: waiting for 'rdbms ipc message'
5: 0: waiting for 'DIAG idle wait'
6: 0: waiting for 'rdbms ipc message'
7: 0: waiting for 'rdbms ipc message'
8: 0: waiting for 'DIAG idle wait'
9: 0: waiting for 'rdbms ipc message'
10: 0: waiting for 'rdbms ipc message'
11: 0: waiting for 'rdbms ipc message'
12: 0: waiting for 'rdbms ipc message'
13: 0: waiting for 'rdbms ipc message'
14: 0: waiting for 'rdbms ipc message'
15: 0: waiting for 'smon timer'
16: 0: waiting for 'rdbms ipc message'
17: 0: waiting for 'rdbms ipc message'
18: 0: waiting for 'rdbms ipc message'
19:
20:
21:
22: 0: waiting for 'Space Manager: slave idle wait'
25: 0: waiting for 'rdbms ipc message'
26: 0: waiting for 'rdbms ipc message'
27: 0: waiting for 'rdbms ipc message'
28: 0: waiting for 'rdbms ipc message'
29: 0: waiting for 'Streams AQ: qmn coordinator idle wait'
30: 0: waiting for 'SQL*Net message from client'
31: 0: waiting for 'rdbms ipc message'
32: 0: waiting for 'SQL*Net message from client'
33: 0: waiting for 'wait for unread message on broadcast channel'
     Cmd: PL/SQL Execute
34: 0: waiting for 'SQL*Net message from client'
35: 0: waiting for 'Streams AQ: qmn slave idle wait'
36: 9: waited for 'Streams AQ: waiting for time management or cleanup tasks'
37: 0: waiting for 'SQL*Net message from client'
38: 0: waiting for 'rdbms ipc message'

NO BLOCKING PROCESSES FOUND

28187 Lines Processed.

欢迎光临重庆思庄Oracle、、PostgreSQL、Redhat认证学习论坛 (http://bbs.cqsztech.com/)