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

 找回密码
 注册

QQ登录

只需一步,快速开始

搜索
查看: 3601|回复: 0
打印 上一主题 下一主题

分析oracle系统 trace文件及dump文件的工具 ass109.awk

[复制链接]
跳转到指定楼层
楼主
发表于 2014-11-6 14:42:04 | 只看该作者 回帖奖励 |倒序浏览 |阅读模式

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.

分享到:  QQ好友和群QQ好友和群 QQ空间QQ空间 腾讯微博腾讯微博 腾讯朋友腾讯朋友
收藏收藏 支持支持 反对反对
回复

使用道具 举报

您需要登录后才可以回帖 登录 | 注册

本版积分规则

QQ|手机版|小黑屋|重庆思庄Oracle、Redhat认证学习论坛 ( 渝ICP备12004239号-4 )

GMT+8, 2024-6-16 18:52 , Processed in 0.085892 second(s), 21 queries .

重庆思庄学习中心论坛-重庆思庄科技有限公司论坛

© 2001-2020

快速回复 返回顶部 返回列表