Skip to Main Content

Oracle Database Discussions

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Index rebuild is so slow

DirdMar 10 2013 — edited Mar 10 2013
Hi guys,

So I've issued a command to move an index to a new tablespace with parallel 12 online with logging.
v$session_longops shows 219 rows related to the alter index sql_id with most of them being "Rowid Range Scan".
It's been running for more than 30 minutes & according to dba_data_files only 3kb has been generated of the 16gb index.
What would be the reason for this moving soooo slowly? Is it the fact theres logging? Would parallel 40 make much difference? Other users don't use the system on Sundays

Edit: There's only 4 cpus (dual core on linux)

Mike

Edited by: Dird on Mar 10, 2013 10:23 AM
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 7 2013
Added on Mar 10 2013
8 comments
2,019 views