Re: RAC "GC Domain Validation" event

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Sat, 18 Nov 2006 17:50:27 -0800
Message-ID: <3b0f44a10611181750h71ce441ak3e795fa419d8cac8@mail.gmail.com>

Ravi,

GC domain validation is a third (or fourth) step during instance recovery. In instance recovery gc domain validation comes after second pass recovery and during gc domain validation SMON isses a recovery lock claim to the IDLM (now GRD) and recovery process proceeds further.

I see no reason for foreground sessions waiting for GC domain validation.. It could be a bug!

-Gopal

On 11/18/06, Ravi_Kulkarni_at_dell.com <Ravi_Kulkarni_at_dell.com> wrote:
>
> Friends,
>
> Anyone here had issue with this event.
>
> A scheduled job (dbms_job) , which is calling a purge Stored Proc is found
> waiting on this event for a long time - causing some of the sessions wait on
> Enq TX-Row lock contention.
>
> Did not get any hits (p1=p2=p3=0).
>
> 10.1.0.5 on RH Linux - 2.4.21-40.ELhugemem #1 SMP
>
> Wondering if the masters can shed some light on what this does…….
>
> Regards,
> Ravi.
>

-- 
Best Regards,
K Gopalakrishnan
Co-Author: Oracle Wait Interface, Oracle Press 2004
http://www.amazon.com/exec/obidos/tg/detail/-/007222729X/

Author: Oracle Database 10g RAC Handbook, Oracle Press 2006
http://www.amazon.com/gp/product/007146509X/

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

Received on Sat Nov 18 2006 - 19:50:27 CST