Home » RDBMS Server » Performance Tuning » Index Rebuild Taking Long
Index Rebuild Taking Long [message #206518] Thu, 30 November 2006 07:18 Go to next message
Messages: 1
Registered: November 2006
Junior Member
Hi All,

We have a scheduled activity for index rebuild which usually takes 12 hours to complete and once it's completed we start the Gather Schema Statistics.
But from past one month the Index rebuild is taking long(18 Hours) for few of the schemas. And we getting the following error for few of the indexes

ORA-00054: resource busy and acquire with NOWAIT specified

I checked the statspack report , but i couldn't figure out anything.

Can anyone help me ?

Re: Index Rebuild Taking Long [message #206535 is a reply to message #206518] Thu, 30 November 2006 08:09 Go to previous message
Mahesh Rajendran
Messages: 10677
Registered: March 2002
Location: oracleDocoVille
Senior Member
Account Moderator
>> We have a scheduled activity for index rebuild
That is usually unnecessary, unless you are loading/modifying huge volumes of data between the schedules.
Scheduled Index rebuilds accomplish nothing. Indexes should be rebuilt only if there is an absolute necesssary.
>>ORA-00054: resource busy and acquire with NOWAIT specified
Means, there might some active session using the said indexes.
Is this an online rebuild?

[Updated on: Thu, 30 November 2006 08:09]

Report message to a moderator

Previous Topic: Automating - Gathering Satistics
Next Topic: Would my SQL work to record which indexes are being used
Goto Forum:

Current Time: Sun Aug 20 21:55:17 CDT 2017

Total time taken to generate the page: 0.10578 seconds