Re: enq HW - contention waits
Date: Sun, 20 Apr 2008 20:58:10 -0500
Yong, we already applied the patch 6376915 in Sep 07. We also use ASSM still there are HW enqueue waits. I think the only other thing to try out would be to preallocate extents to the LOB tables. Let me know if you've any other ideas.
On Sat, Apr 19, 2008 at 8:14 PM, Yong Huang <yong321_at_yahoo.com> wrote:
> I just saw Bug 6376915 "HW enqueue contention for ASSM LOB segments". I
> there're lots of bug reports about HW enqueue and LOB. But this one is
> specifically about ASSM. It implies HW enqueue for LOB is more easily
> in ASSM. But my test in a 10.2.0.3 database that uses two sessions only
> produces HW locks when the LOB is in a non-ASSM tablespace, and not in
> Yong Huang
> --- Yong Huang <yong321_at_yahoo.com> wrote:
> > Is your tablespace ASSM? If not, consider moving the LOB segment to an
> > tablespace because it's more difficult to create HW contention on ASSM.
> > Yong Huang
> Be a better friend, newshound, and
> know-it-all with Yahoo! Mobile. Try it now.