Re: Table locked while rebuilding index

From: MK <hello_at_foo.com>
Date: Thu, 1 May 2003 20:15:11 +0200
Message-ID: <b8ro7o$coq11$1@ID-174077.news.dfncis.de>

"MK" <hello_at_foo.com> wrote

[...]

War report, #2

I had to import 1 billion rows into a table. I put INDEXES=Y into the IMP par file, however it was difficult to see what was Oracle doing. I had several server session making full table scan of that table (after the message "1 billion rows imported"), presumably to rebuild the index? But why? I expected that INDEXES=Y just imports indexes, without rebuilding/reprocessing anything? BTW that export file was of course also made with INDEXES=Y.

I simply killed off all those sessions and ran a CREATE INDEX... script. With PARALLEL option on, but it still takes ages. BTW I have PARALLEL 2, but both processors on my machine show only 50% CPU usage. Should I put PARALLEL 4 or 8 next time? Received on Thu May 01 2003 - 13:15:11 CDT