We have found that using Oracle to gather databases statistics will not complete successfully (i.e. processes for 24hours and never finishes). Looking at the spatial and attribute indexes on the feature classes via ArcCatalog everything appears as expected and indicates that there is a spatial index. Using SQL Developer to query the S***_IDX$ tables, it is noticed that they are indeed populated with information. However the SDE.ST_GEOMERTY_INDEX table has null values for columns such as BLEVEL, LEAF_BLOCKS, CLUSTERING_FACTOR. If the spatial index is recalculated (via command line or via ArcCatalog) and then the feature class analyzed, these values are updated and Oracle's gather statistics will then complete in a matter of minutes.
Two questions:
1. Why are these columns empty in the first place? We often use the FeatureClassToFeatureClass tool to load data.
2. Why is does the Oracle gather statistics operation fail if the statistics on the spatial indexes are missing?
Oracle 11g (Unix)
SDE 10.0 SP3 (Windows)
ArcGIS Desktop 10.0 SP3
Sandra
