Re: index_stats no populating

From: Anurag Varma <avoracle_at_gmail.com>
Date: 20 Jan 2006 12:25:23 -0800
Message-ID: <1137788723.377214.259930@g14g2000cwa.googlegroups.com>

Ben,

Then its possible you might be hitting some bug as Yong suggested. You would have to open an iTar for it....

One last thing I wanted to point out:
analyze index .... validate structure ONLINE; will not populate index_stats at least until 10.1.0.2 (although you do not state using this option .. I thought I'd point this out).

while analyze index ... validate structure; should populate index_stats .. or fail with an error if the index structure is not valid (corrupt).

Anurag Received on Fri Jan 20 2006 - 14:25:23 CST