HW Enqueue

From: Russell Brooks <russell.brooks_at_amctechnology.com>
Date: Tue, 22 Aug 2000 18:08:15 -0400
Message-Id: <10597.115305@fatcity.com>

Hi,
We're running a conversion that is inserting like mad into a single table. I'm seeing a fair number of enqueues. A select p1, p2, p3 from v$session_wait where event = 'enqueue'; gives several rows of

P1		P2	P3
1213661190	75	33618434

If I run a
select chr(bitand(p1, -16777216)/16777215)|| chr(bitand(p1,16711680)/65535) Enqueue
from v$session_wait
where event = 'enqueue';
I get

ENQUE
HW
HW
HW
...

My assumption is we're hitting contention on a latch associated with resetting the high water mark. The initial and next extents are 10 MB. I recall something about this situation, but can't find the reference. Has anyone else heard of this?

Cheers, Received on Tue Aug 22 2000 - 17:08:15 CDT