Re: "resmgr:method mem alloc latch" latch

Connor,

I recall that in 9.2.0.5 we had to set "system_plan" in order to be able to coalesce (for online building logical standby). Otherwise, resource manager is not enabled. Perhaps, later 9i releases have different behavior.
Btw, enabling resource manager did cause issues for very active instances but it was a different latch. Can't recall it from the top of my head.

Alex

On 6/7/07, Connor McDonald <mcdonald.connor_at_gmail.com> wrote:
> Just a guess here -
>
> Some versions of 9 used to default the resource manager plan to
> "system_plan" or something like that, so you had resource manager enabled by
> default even if you didn't want it.
>
> hth
> Connor
>
> -----Original Message-----
> From: oracle-l-bounce_at_freelists.org [mailto:oracle-l-bounce_at_freelists.org]
> On Behalf Of Hameed, Amir
> Subject: "resmgr:method mem alloc latch" latch
>
> Folks,
> I was seeing a session waiting on the following latch in our QA database
> (9.2.0.6). I could not find anything on this latch. Does anyone know what
> this latch does and under what circumstances this latch is waited on?
>
> Thanks
> Amir
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
> --
> http://www.freelists.org/webpage/oracle-l
>
>
>

-- 
Best regards,
Alex Gorbachev

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