分析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.