Re: enq HW - contention waits

From: Riyaj Shamsudeen <>
Date: Tue, 22 Apr 2008 09:09:37 -0500
Message-ID: <>

  I must be missing something here. Just to clarify, are you saying that allocating an extent add space under HWM? Do you have any reference or test case?

>> alter table theBLOBtable modify lob (theBLOBcolumn) (allocate extent
(instance 1));
>> Remember to include the "instance 1" so space is added below HWM, even if
you're not using RAC (ignore documentation's caution: only use it on RAC).

Riyaj Shamsudeen
The Pythian Group

On Sun, Apr 20, 2008 at 8:58 PM, Ravi Gaur <> wrote:

> 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.
> Thank you.

Received on Tue Apr 22 2008 - 09:09:37 CDT

Original text of this message