truncate causing enqueues?

From: Russell Brooks <russell.brooks_at_amctechnology.com>
Date: Wed, 20 Sep 2000 21:47:51 -0400
Message-Id: <10625.117521@fatcity.com>

Hi all,
We had a reasonably idle system, and kicked a create index with degree 10. Everything looks nice. We issue a truncate of a table in a different tablespace, and within a few minutes every create index process shows an enqueue. As far as we can tell, the create index comes to a complete halt. Kill the truncate, the enqueues go away, and the create index completes. We're going to do some more poking at it, but anyone seen this?

Cheers,
Russ Brooks Received on Wed Sep 20 2000 - 20:47:51 CDT