Oracle 9i&10g可用的ass.awk

最新推荐文章于 2023-12-27 11:22:38 发布

zjysun

最新推荐文章于 2023-12-27 11:22:38 发布

阅读量988

点赞数

分类专栏： Oracle學習文章标签： oracle object file processing resources thread

本文链接：https://blog.csdn.net/zjysun/article/details/4982526

版权

Oracle學習专栏收录该内容

10 篇文章 0 订阅

订阅专栏

首先把ass109.awk文件上传到服务器/opt目录下，rpt1_ora_4974.trc也在/opt目录下。

[root@WESTZQ opt]# awk -f ass109.awk rpt1_ora_4974.trc

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

System State 1
~~~~~~~~~~~~~~~~
1:
2: waiting for 'pmon timer'            seq=35586
3: waiting for 'rdbms ipc message'     seq=45324
4: waiting for 'rdbms ipc message'     seq=61799
5: waiting for 'rdbms ipc message'     seq=13234
6: waiting for 'buffer busy waits' (11,709,dc) seq=27783
7: waiting for 'rdbms ipc message'     seq=132
8: waiting for 'rdbms ipc message'     seq=19660
9: waiting for 'log file switch (archiving needed)' seq=18401
     Cmd: Select

……

Blockers
~~~~~~~~

        Above is a list of all the processes. If they are waiting for a resource
        then it will be given in square brackets. Below is a summary of the
        waited upon resources, together with the holder of that resource.
        Notes:
        ~~~~~
         o A process id of '???' implies that the holder was not found in the
           systemstate.

                    Resource Holder State
Enqueue PR-00000000-00000000    41: last wait for 'os thread startup'
      Latch c0000000c2df3b70    ??? Blocker
Rcache object=c000000f9fdf8160,    61: waiting for 'log file switch (checkpoint incomplete)'
Enqueue US-0000004C-00000000   185: waiting for 'log file switch (checkpoint incomplete)'
Enqueue FB-00000006-0186BDC8   187: waiting for 'log file switch (checkpoint incomplete)'
LOCK: handle=c000000f388db3d0   204: waiting for 'log file switch (checkpoint incomplete)'

Object Names
~~~~~~~~~~~~
Rcache object=0x5bf3945c,

58315 Lines Processed.