Re: Merge partitions

From: Mladen Gogala <mgogala.spam-me-not_at_verizon.net>
Date: Sun, 17 Dec 2006 05:06:22 GMT
Message-Id: <pan.2006.12.17.05.06.22.543540@verizon.net>

On Sat, 16 Dec 2006 16:42:13 -0800, hpuxrac wrote:

>
> If you turn on ( and then back off ) a 10046 trace what wait events are
> showing up?

The problem was in a function-based bitmap index. I ran out of the alloted maintenance time and killed the process. For some reason, it took horribly long to build the new index. It was doing single block reads, for a fairly large table.
It serves me right, I should have tried this on the staging database before going alive.

-- 
http://www.mladen-gogala.com

Received on Sat Dec 16 2006 - 23:06:22 CST