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

  • From: K Gopalakrishnan <kaygopal@xxxxxxxxx>
  • To: grzegorzof@xxxxxxxxxx
  • Date: Wed, 4 May 2011 10:30:46 -0500

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@xxxxxxxxxx
> 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
>
> --
> //www.freelists.org/webpage/oracle-l
>
>
>

Other related posts: