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

From: Leyi Zhang (Kamus) <"Leyi>
Date: Thu, 5 May 2011 11:52:49 +0800
Message-ID: <BANLkTinKtqtNuD2oL6WH62WyNWrDn0zvhg_at_mail.gmail.com>

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

--
Kamus <kamusis_at_gmail.com>

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_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 - 22:52:49 CDT