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

Check this doc for short guide into reading hanganalyze:

http://www.rmoug.org/td2005pres/Haisley2.zip

Also look into ML note 215858.1

At least from this hanganalyze info you sent I don't find any blockers, few points though:

1. The pmon was not waiting on KJC receiver queue access list latch at the time. However the last PMONs wait had been on this lath
2. KJC stuff should be RAC lock manager related. Do you have RAC linked in to your binary perhaps? (select from v$option)
3. To which segment does block 486504 in file# 58 belong to?

Tanel.

> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org
> [mailto:oracle-l-bounce_at_freelists.org] On Behalf Of Allen, Brandon
> Sent: Thursday, January 11, 2007 02:20
> To: Allen, Brandon; Tanel Poder; oracle-l
> Subject: RE: Rollback waiting on 'cache buffer chains' latch - SOLVED
>
> 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/finis
> h/[adjlist
> ]/predecessor):
> [0]/0/1/1/0x3796f90/1310784/SINGLE_NODE_NW/1/2//none
>
>

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