Q
Problem solve Get help with specific problems with your technologies, process and projects.

Oracle's online rebuild capability

We have a database of around 1 TB and we have to rebuild the indexes frequently. Since the loads are running we have to wait for a long period of time to rebuild the indexes. Can we use the rebuild online feature of Oracle8i? Will it affect the performance of loads running?
First, I'd want to know why you have to rebuild indexes frequently. Periodic index rebuilds are not generally necessary. However, if you have a valid reason for doing rebuilds, such as index invalidation due to direct-path data loads, you do want to take advantage of Oracle's online rebuild capability. The performance effects should be minimal; the old index is still available for use by queries while it's being rebuilt. You should review the SQL Reference Manual for restrictions on index rebuilding.

Dig Deeper on Oracle database performance problems and tuning

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.

-ADS BY GOOGLE

SearchDataManagement

SearchBusinessAnalytics

SearchSAP

SearchSQLServer

TheServerSide.com

SearchDataCenter

SearchContentManagement

SearchHRSoftware

Close