Index rebuild is so slow
DirdMar 10 2013 — edited Mar 10 2013Hi 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