Printable View
Hi,
In my production database, space in index tablespace increasing very fastly. So i wanted to search the indexes those are candidates for rebuilding.But when i gave statement:
ANALYZE INDEX INDEX_NAME VALIDATE STRUCTURE;
I got error:
ORA-00054: resource busy and acquire with NOWAIT specified
Can you please provide the solution to solve this error?
Does rebuilding the indexes increase the space utility and performance?
As said in http://groups.google.com/group/comp....2e05f089babeb1 , validate structure WANT a non-changing structure, so it tries to put a LOCK , if you are receiving "resource busy", quite obviously someone IS using the structure, lock is not possible... Execute the command in another time/period, when no-one is using the index.
To see who is using it, check the lock-related views and see the PL/SQL currently running.
[]s
Chiappa
and I bet you dont need to rebuild your indexes