Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: Table locked while rebuilding index
Dear MK,
I am sorry you haven't tested on a test system before or fully understood
the implications of your statements - especially when the need for
availability of the system is that big, but hey, that can happen to me too.
With regards to the 50% usage of your processors: perhaps there is
disk-contention (on unix: run a SAR report).
Good luck with your endeaours,
Best regards,
Erik
"MK" <hello_at_foo.com> wrote in message
news:b8ro7o$coq11$1_at_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:53:22 CDT
![]() |
![]() |