Discuz教程网

哪位高手能解读一下线面的trace文件内容?post info什么意思?

[复制链接]
authicon 飞飞 发表于 2010-10-26 03:43:47 | 显示全部楼层 |阅读模式

PROCESS STATE
-------------
Process global information:
     process: 700000200662cc0, call: 7000001dde6bb58, xact: 0, curses: 70000020386ed28, usrses: 70000020386ed28
  ----------------------------------------
  SO: 700000200662cc0, type: 2, owner: 0, flag: INIT/-/-/0x00
  (process) Oracle pid=243, calls cur/top: 7000001dde6bb58/7000001dde6bb58, flag: (0) -
            int error: 0, call error: 0, sess error: 0, txn error 0
  (post info) last post received: 0 0 117
              last post received-location: kcbzww
              last process to post me: 700000200664c40 164 0
              last post sent: 0 0 117
              last post sent-location: kcbzww
              last process posted by me: 700000200639740 173 0
    (latch info) wait_event=0 bits=0
    Process Group: DEFAULT, pseudo proc: 7000002006bc340
    O/S info: user: oracle, term: UNKNOWN, ospid: 1065098
    OSD pid info: Unix process pid: 1065098, image: oracle@rac01
Dump of memory from 0x0700000200610848 to 0x0700000200610A50
700000200610840                   0000001A 00000000          [........]
700000200610850 07000001 DDDF59E0 00000010 000313A7  [......Y.........]
700000200610860 07000001 DDE6BB58 00000003 000313A7  [.......X........]
700000200610870 07000002 00CB2298 00000013 0003129B  [......".........]
700000200610880 07000002 03CEBFE8 0000000B 000313A7  [................]
700000200610890 07000002 0386ED28 00000004 0003129B  [.......(........]
*********************************************************************
    KGX Atomic Operation Log 7000001c5a20e28
       Mutex 7000001943791e0(0, 2) idn 9e178560 oper SHRD
       Cursor Pin uid 992 efd 0 whr 5 slp 13
       opr=4 pso=7000001e9d23718 flg=0
       pcs=7000001943791e0 nxt=0 flg=18 cld=2 hd=70000020241a9d0 par=7000000fe8c2bb8
       ct=7 hsh=0 unp=0 unn=0 hvl=fe8c2548 nhv=0 ses=0
       hep=700000194379260 flg=80 ld=1 ob=7000000aaace500 ptr=7000001141a61d8 fex=7000001141a54e8
      ----------------------------------------
      SO: 7000001e9bc0490, type: 53, owner: 70000020394a3c8, flag: INIT/-/-/0x00
      LIBRARY OBJECT LOCK: lock=7000001e9bc0490 handle=7000001b654de88 mode=N
      call pin=0 session pin=0 hpc=0000 hlc=0000
      htl=7000001e9bc0510[7000001ddc74d08,7000001e9d23798] htb=7000001ddc74d08 ssga=7000001ddc745f0
      user=70000020394a3c8 session=70000020394a3c8 count=1 flags=[0000] savepoint=0x4c96d213
      LIBRARY OBJECT HANDLE: handle=7000001b654de88 mtx=7000001b654dfb8(2) cdp=2
      name=*********
       hash=9323114d05bebc82f84c83fb9e178560 timestamp=09-19-2010 08:22:50
      namespace=CRSR flags=RON/KGHP/TIM/PN0/KST/DBN/MTX/[100100d0]
      kkkk-dddd-llll=0000-0001-0001 lock=N pin=0 latch#=2 hpc=00a6 hlc=00a6
      lwt=7000001b654df30[7000001b654df30,7000001b654df30] ltm=7000001b654df40[7000001b654df40,7000001b654df40]
      pwt=7000001b654def8[7000001b654def8,7000001b654def8] ptm=7000001b654df08[7000001b654df08,7000001b654df08]
      ref=7000001b654df60[7000001b654df60,7000001b654df60] lnd=7000001b654df78[7000001b654df78,7000001b654df78]
        LIBRARY OBJECT: object=7000000fe8c2aa0
        type=CRSR flags=EXS[0001] pflags=[0000] status=VALD load=0
        CHILDREN: size=16
        child#    table reference   handle
        ------ -------- --------- --------
             0 7000000fe8c2568 7000000fe8c21d8 7000000fa40dca0
             1 7000000fe8c2568 7000000fe8bf010 7000000fa40d790
             2 7000000fe8c2568 700000194379438 70000020241a9d0
        DATA BLOCKS:
        data#     heap  pointer    status pins change whr
        ----- -------- -------- --------- ---- ------ ---
            0 7000001b654ddc8 7000000fe8c2bb8 I/P/A/-/-    0 NONE   00
      ----------------------------------------



上一篇:将csv文件用sqlldr导入时,数据格式的问题
下一篇:哪里有复杂的dblink查询语句可以参考一下?
authicon renxiao2003 发表于 2010-10-26 04:53:36 | 显示全部楼层

难啊。帮顶。
authicon duolanshizhe 发表于 2010-10-26 08:14:07 | 显示全部楼层

楼主需要解决什么问题
这个文件要全部解读  那是需要相当费工夫的啊
authicon xlghr 发表于 2010-10-26 09:08:23 | 显示全部楼层
楼主需要解决什么问题
这个文件要全部解读  那是需要相当费工夫的啊
duolanshizhe 发表于 2010-09-21 16:30
    就是想研究一下,学习怎么解读,一便于分析故障
authicon duolanshizhe 发表于 2010-10-26 10:48:46 | 显示全部楼层

说实在话  要想全部读懂  你需要好好看看DSI
您需要登录后才可以回帖 登录 | 立即注册

本版积分规则

1314学习网 ( 浙ICP备10214163号 )

GMT+8, 2025-5-2 18:16

Powered by Discuz! X3.4

© 2001-2013 Comsenz Inc.

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