Statistics in Oracle databases
You can use the DBMS_STATS package to update statistics in Oracle databases. To update statistics for a particular table, you can use the Analyze command in ArcGIS for Desktop.
See Updating statistics on a geodatabase using Analyze for information on the Analyze command. See your Oracle documentation for information on the DBMS_STATS package.

If you do not have enough temporary tablespace to compute statistics on larger tables, increase the size of your temporary tablespace.
Related Topics
4/2/2015