Updating geodatabase statistics in Oracle databases
Updating geodatabase statistics in Oracle databases
|
Release 9.3 |
|
The following settings can impact how Oracle database statistics are updated:
- The ArcSDE technology has been developed as an online transaction processing (OLTP) system. As such, Oracle initialization parameters geared toward optimizing data warehousing queries adversely affect the performance of ArcSDE queries and should not be used. The STAR_TRANSFORMATION_ENABLED parameter should be set to FALSE. You should create the Oracle database using an OLTP template and not a data warehousing template. You should not enable parallel execution on the ArcSDE schema.
- If you do not have enough temporary table space to compute statistics on larger tables, use the –m option of the sdedbtune update_dbms_stats operation to estimate statistics. The tables are estimated at a sample rate of 33 percent.
sdetable –o update_dbms_stats –t roads –m estimate –u av –p mo
NOTE: You should consider increasing the size of your temporary table space to compute statistics rather than estimate them because it provides more accurate statistics for the Oracle cost-based optimizer.