When executing the Oracle analyze or dbms_stats command, the following Oracle error displays:
ERROR at line 1:
ORA-29927: error in executing the ODCIStatsCollect / ODCIStatsDelete routine
ORA-30562: SAMPLE percentage must be in the range [0.000001,100)
ORA-06512: at "SYS.DBMS_SYS_SQL", line 906
ORA-06512: at "SYS.DBMS_SQL", line 39
ORA-06512: at "SDE.ST_DOMAIN_STATS", line 349
If a table contains more than 2.5 million rows and the sample size for estimating statistics is either 0 or 100 when gathering statistics on a table with an St_Geometry attribute (a spatial index), the command encounters the following Oracle error:
"ORA-30562: SAMPLE percentage must be in the range [0.000001,100)".
The internal problem for the spatial type's index function for gathering statistics is that the function executes a query using the Oracle clause SAMPLE BLOCK (percentage) so the value for percentage must be between 0.000001 and 99.
SQL> EXECUTE dbms_stats.gather_table_stats(user,'PARCELS',NULL,10);
PL/SQL procedure successfully completed.