Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Analyzing indexes
I need to determine whether or not a couple of indexes need to be
rebuilt. The problem is the indexes are quite large and on a 24x7 high
volume database. If I try to run an "analyze validate structure" to
gather the data I need to make that decision, it sets a lock on the
table for about an hour which I can't afford to do. There is no slow
time when I can do this and management has said before they're not going
to spring for the partitioning option to break the indexes up into
managable pieces. Is there some other way I can get the information
needed to determine if an index needs to be rebuilt or not without
setting a lock on the table? We are on Oracle 8.1.7.
Received on Tue Mar 11 2003 - 08:38:05 CST