Re: V$GCSPFMASTER_INFO shows only undo segments even if _gc_affinity_time 10

From: K Gopalakrishnan <kaygopal_at_gmail.com>
Date: Wed, 4 May 2011 10:30:46 -0500
Message-ID: <BANLkTi=AUBffU3nawf89Z92dBK3GXhXTkg_at_mail.gmail.com>

Greg,
V$GCSPFMASTER_INFO is not very reliable to monitor DRM till 11.1. Check the bug 5649377.

-Gopal

On Wed, May 4, 2011 at 10:18 AM, Grzegorz Goryszewski <grzegorzof_at_interia.pl
> wrote:

> Hi,
> I'm on 4-node Linux RAC 10.2.0.3 , recently I've notice that only undo
> segments are showed in V$GCSPFMASTER_INFO
> I know that because object_id is like 4294950913 and so .
> Thats strange because I'm expecting other objects to be remastered,
> there is :
>
> |_gc_affinity_time 10
> _gc_affinity_limit 50
>
> and I can see :
> DRM(29) ignoring dissolve of 18504741
> * kjdrchkdrm: found an RM request in the request queue
> Dissolve pkey 18504742
> DRM(29) ignoring dissolve of 18504742
> * kjdrchkdrm: found an RM request in the request queue
> Dissolve pkey 18504743
> DRM(29) ignoring dissolve of 18504743
> * kjdrchkdrm: found an RM request in the request queue
> Dissolve pkey 18504744
> |
>
>
>
> in lmd0 trace .
> So how can I check DRM is on or off ?:)
> Regards.
> GregG
>
> -------------------------------------------------
> Zapytaj wrozke!
> Sprawdz >> http://linkint.pl/f29a2
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

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

Received on Wed May 04 2011 - 10:30:46 CDT