ass109.awk脚本学习使用

核心提示： SQL> oradebug setmypidStatement processed.SQL> oradebug unlimitStatement processed.SQL> oradebug dump systemstate 266Statement processed.SQL> orad

 SQL> oradebug setmypid
Statement processed.
SQL> oradebug unlimit
Statement processed.
SQL> oradebug dump systemstate 266
Statement processed.
SQL> oradebug tracefile_name
/oracle/ora10g/admin/jscn/udump/jscn1_ora_7755.trc
SQL> exit
Disconnected from Oracle Database 10g Enterprise Edition Release 10.2.0.4.0 - 64 bit Production
With the Partitioning, Real Application Clusters, OLAP, Data Mining
and Real Application Testing options
[oracle@scrac1 ~]$ vim /oracle/ora10g/admin/jscn/udump/jscn1_ora_7755.trc
[oracle@scrac1 ~]$ awk -f ass109.awk /oracle/ora10g/admin/jscn/udump/jscn1_ora_7755.trc

Starting Systemstate 1
..............................................................................
...............................................................................
..............................
Ass.Awk Version 1.0.9 - Processing /oracle/ora10g/admin/jscn/udump/jscn1_ora_7755.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 'gcs remote message' wait
12: waiting for 'gcs remote 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 'rdbms ipc message' wait
17: waiting for 'rdbms ipc message' wait
18: waiting for 'rdbms ipc message' wait
19: waiting for 'smon timer' wait
20: waiting for 'rdbms ipc message' wait
21: waiting for 'rdbms ipc message' wait
22: waiting for 'rdbms ipc message' wait
23: waiting for 'rdbms ipc message' wait
24:
25:
26: waiting for 'rdbms ipc message' wait
27: waiting for 'SQL*Net message from client' wait
28: waiting for 'ASM background timer' wait
29: waiting for 'rdbms ipc message' wait
30: waiting for 'SQL*Net message from client' wait
31: waiting for 'rdbms ipc message' wait
32: waiting for 'rdbms ipc message' wait
33: waiting for 'Streams AQ: qmn coordinator idle wait' wait
34: waiting for 'SQL*Net message from client' wait
35: waiting for 'SQL*Net message from client' wait
36: waiting for 'jobq slave wait' wait
37: waiting for 'SQL*Net message from client' wait
38: waiting for 'jobq slave wait' wait
39: waiting for 'jobq slave wait' wait
40: waiting for 'SQL*Net message from client' wait