RE: Rollback waiting on 'cache buffer chains' latch

From: Allen, Brandon <Brandon.Allen_at_OneNeck.com>
Date: Wed, 10 Jan 2007 11:19:56 -0700
Message-ID: <04DDF147ED3A0D42B48A48A18D574C45059E27A2@NT15.oneneck.corp>

I don't have much experience reading hanganalyze or systemstate dumps, but below is what I found regarding the pmon process in case it means anything to any of you. As far as I can tell, it looks like pmon was waiting on this latch:

SQL> select name from v$latch where latch#=62;

NAME

KJC receiver queue access list

I couldn't find anything about this latch on Metalink or Google.

HANGANALYZE:

Other chains found:
Chain 2 : <cnode/sid/sess_srno/proc_ptr/ospid/wait_event> :

<0/1/1/0x35968e0/1310784/No Wait>

State of nodes
([nodenum]/cnode/sid/sess_srno/session/ospid/state/start/finish/[adjlist ]/predecessor):
[0]/0/1/1/0x3796f90/1310784/SINGLE_NODE_NW/1/2//none

SYSTEMSTATE:

PROCESS 2:

SO: 7000001035968e0, type: 2, owner: 0, flag: INIT/-/-/0x00 (process) Oracle pid=2, calls cur/top: 700000103bdcbf0/700000103bdcbf0, flag: (e) SYSTEM

int error: 0, call error: 0, sess error: 0, txn error 0 (post info) last post received: 504403162639456880 98 2

              last post received-location: kslges
              last process to post me: 7000001035b69e0 93 0
              last post sent: 0 0 16
              last post sent-location: ksasnd
              last process posted by me: 700000103597390 1 6

(latch info) wait_event=0 bits=0
Process Group: DEFAULT, pseudo proc: 70000010378dd18 O/S info: user: oracle, term: UNKNOWN, ospid: 1310784 OSD pid info: Unix process pid: 1310784, image: oracle_at_gbtbaan01 (PMON) <<snip lots of "SO: (FOB)" lines >>

SO: 700000103796f90, type: 4, owner: 7000001035968e0, flag: INIT/-/-/0x00
(session) trans: 0, creator: 7000001035968e0, flag: (51) USR/- BSY/-/-/-/-/-

          DID: 0001-0002-00000002, short-term DID: 0000-0000-00000000
          txn branch: 0
          oct: 0, prv: 0, sql: 700000109db1130, psql: 0, user: 0/SYS
last wait for 'latch free' blocking sess=0x0 seq=10565 wait_time=9782
            address=700000104b55a70, number=62, tries=0

temporary object counter: 0

<<snip>>

SO: 7000001046259f0, type: 24, owner: 700000103bdcbf0, flag: INIT/-/-/0x00
(buffer) PR: 0x7000001035968e0 FLG: 0x0
lock rls: 0x0, class bit: 0x2
kcbbfbp: [BH: 0x7000000b6ff0f00, LINK: 0x700000104625a30] where: kdiwh22: kdifind, why: 0
BH (0x7000000b6ff0f00) file#: 58 rdba: 0x0e876c68 (58/486504) class 1 ba: 0x7000000b6dde000
  set: 6 dbwrid: 0 obj: 64903 objn: 64903   hash: [70000010495c4c0,7000000e4f83900] lru:
[7000000b6fc8568,7000000e1fd1868]

  LRU flags: hot_buffer
  ckptq: [NULL] fileq: [NULL]
  st: XCURRENT md: NULL rsop: 0x0 tch: 214   flags: gotten_in_current_mode block_written_once redo_since_read   LRBA: [0x0.0.0] HSCN: [0xffff.ffffffff] HSUB: [1] RRBA: [0x0.0.0]   buffer tsn: 20 rdba: 0x0e876c68 (58/486504)   scn: 0x0000.b21930b2 seq: 0x01 flg: 0x04 tail: 0x30b20601   frmt: 0x02 chkval: 0x0084 type: 0x06=trans data

<< snip - 2 block dumps >>

-----Original Message-----
From: oracle-l-bounce_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]

It occurs to me now that I should've checked to see what the PMON process was waiting on, but for some reason I never thought to check that yesterday - too late now. Well maybe it will show me in the hanganalyze dump . . .

Thanks,
Brandon

Privileged/Confidential Information may be contained in this message or attachments hereto. Please advise immediately if you or your employer do not consent to Internet email for messages of this kind. Opinions, conclusions and other information in this message that do not relate to the official business of this company shall be understood as neither given nor endorsed by it.

--
http://www.freelists.org/webpage/oracle-l

Received on Wed Jan 10 2007 - 12:19:56 CST

RE: Rollback waiting on 'cache buffer chains' latch - SOLVED