Re: "resmgr:method mem alloc latch" latch

  • From: "Alex Gorbachev" <gorbyx@xxxxxxxxx>
  • To: mcdonald.connor@xxxxxxxxx
  • Date: Sat, 9 Jun 2007 21:24:30 -0400

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@xxxxxxxxx> 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@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
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

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


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





--
Best regards,
Alex Gorbachev

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


Other related posts: