RE: Rollback waiting on 'cache buffer chains' latch - SOLVED
- From: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>
- To: "Allen, Brandon" <Brandon.Allen@xxxxxxxxxxx>, "Tanel Poder" <tanel.poder.003@xxxxxxx>, "oracle-l" <oracle-l@xxxxxxxxxxxxx>
- Date: Wed, 10 Jan 2007 11:19:56 -0700
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@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@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
