| Index Rebuild Taking Long [message #206518] |
Thu, 30 November 2006 07:18  |
nikhilpaneri
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 ?
Thanks
|
|
|
|
| Re: Index Rebuild Taking Long [message #206535 is a reply to message #206518] |
Thu, 30 November 2006 08:09  |
 |
Mahesh Rajendran
Messages: 10708
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 |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
