There are several dozen possible tuning parameters (both Oracle- and ArcSDE-specific), and
scores of configuration options for thousands of possible use cases. I haven't ever changed
a tuning parameter that had a even a fraction of the positive impact of increasing the default
1/10th millimeter precision of ArcGIS-generated coordinate references to something in the
5 centimeter range. Next most significant was optimizing the features in spatial index order.
All database tuning options (for all databases) pale in comparison to making sure the system
has robust I/O performance with multiple independent disks tuned to the database transfer
blocksize, organizing the data to utilize parallelism in disk access, keeping the redo logs and
temp tablespace apart from each other and data tables, and organizing the data in the tables
for optimal query performance.
- V