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 rebuilding slow in Oracle 10g

689431Mar 14 2009 — edited Mar 15 2009

We are trying to build indexes in Oracle 10g and its extremely slow. Any pointers to find out what the problem is and then fixing it?

I am using a syntax like:

alter index INDEX_NAME rebuild tablespace TABLESPACE_NAME online compute statistics parallel;

Should online and parallel together be an issue? (I don't necessarily need to do online, I just removed online and started again, but not sure how it will go)

Locked Post

New comments cannot be posted to this locked post.

Locked on Apr 12 2009

Added on Mar 14 2009

#general-database-discussions

7 comments

2,902 views