ass109.awk脚本包含在LTOM431版本中，主要用于分析systemstate生成的trace文件。
示例如下：

[root@pr7 ~]# awk -f ass109.awk lsyy1_ora_17433530.trc

Starting Systemstate 1
..............................................................................
...............................................................................
...............................................................................
...............................................................................
...............................................................................
...............................................................................
...............................................................................
...............................................................................
...............................................................................
...............................................................................
....................................................
Ass.Awk Version 1.0.9 - Processing lsyy1_ora_17433530.trc

System State 1
~~~~~~~~~~~~~~~~
1:                                      
2:  waiting for 'pmon timer'            wait
3:  waiting for 'DIAG idle wait'        wait
4:  waiting for 'rdbms ipc message'     wait
5:  waiting for 'rdbms ipc message'     wait
6:  waiting for 'ges remote message'    wait
7:  waiting for 'gcs remote message'    wait
8:  waiting for 'gcs remote message'    wait
9:  waiting for 'gcs remote message'    wait
10: waiting for 'gcs remote message'    wait
11: waiting for 'rdbms ipc message'     wait
12: waiting for 'rdbms ipc message'     wait
13: waiting for 'rdbms ipc message'     wait
14: waiting for 'rdbms ipc message'     wait
15: waiting for 'rdbms ipc message'     wait
16: waiting for 'smon timer'            wait
17: waiting for 'rdbms ipc message'     wait
18: waiting for 'rdbms ipc message'     wait
19: waiting for 'rdbms ipc message'     wait
20: waiting for 'rdbms ipc message'     wait
21:                                     
22:                                     
23: waiting for 'rdbms ipc message'     wait
24: waiting for 'jobq slave wait'       wait
25: waiting for 'ASM background timer'  wait
26: waiting for 'rdbms ipc message'     wait
27: waiting for 'SQL*Net message from client' wait
28: waiting for 'SQL*Net message from client' wait
29: waiting for 'SQL*Net message from client' wait
30: waiting for 'SQL*Net message from client' wait
31: waiting for 'SQL*Net message from client' wait
     Cmd: Select
32: waiting for 'SQL*Net message from client' wait
33: waiting for 'SQL*Net message from client' wait
34: waiting for 'SQL*Net message from client' wait
     Cmd: Select
35: waiting for 'SQL*Net message from client' wait
     Cmd: Select
36: waiting for 'SQL*Net message from client' wait
     Cmd: Select
37: waiting for 'SQL*Net message from client' wait
     Cmd: Select
38: waiting for 'SQL*Net message from client' wait
     Cmd: Select
39: waiting for 'SQL*Net message from client' wait
     Cmd: Select
40: waiting for 'SQL*Net message from client' wait
41: last wait for 'ksdxexeotherwait'    
42: waiting for 'SQL*Net message from client' wait
     Cmd: Select
43: waiting for 'rdbms ipc message'     wait
44: waiting for 'rdbms ipc message'     wait
45: waiting for 'SQL*Net message from client' wait
46: waiting for 'Streams AQ: qmn coordinator idle wait' wait
47: waiting for 'jobq slave wait'       wait
48: waiting for 'jobq slave wait'       wait
49: waiting for 'jobq slave wait'       wait
50: waiting for 'jobq slave wait'       wait
51: for 'Streams AQ: waiting for messages in the queue' wait
52: for 'Streams AQ: waiting for time management or cleanup tasks' wait
53: waiting for 'SQL*Net message from client' wait
54: waiting for 'Streams AQ: delete acknowledged messages' wait
55: waiting for 'SQL*Net message from client' wait
     Cmd: Select
56: waiting for 'SQL*Net message from client' wait
     Cmd: PL/SQL Execute
...省略
997:waiting for 'SQL*Net message from client' wait
1000:waiting for 'SQL*Net message from client' wait
1003:waiting for 'SQL*Net message from client' wait
     Cmd: Select
1005:waiting for 'SQL*Net message from client' wait
     Cmd: Select
1008:waiting for 'SQL*Net message from client' wait
     Cmd: Select
1011:waiting for 'SQL*Net message from client' wait
1012:waiting for 'SQL*Net message from client' wait
     Cmd: Select
1015:waiting for 'SQL*Net message from client' wait
     Cmd: Select

NO BLOCKING PROCESSES FOUND


3075273 Lines Processed.
复制