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

  • From: "Leyi Zhang (Kamus)" <kamusis@xxxxxxxxx>
  • To: grzegorzof@xxxxxxxxxx
  • Date: Thu, 5 May 2011 11:52:49 +0800

If you use "oradebug lkdebug -m pkey" command to manually remaster the
object, can you find it in v$gcspfmaster_info?

--
Kamus <kamusis@xxxxxxxxx>

Visit my blog for more : http://www.dbform.com
Join ACOUG: http://www.acoug.org



On Wed, May 4, 2011 at 11:18 PM, 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
>
>
>
--
//www.freelists.org/webpage/oracle-l


Other related posts: