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