English

FAQ: What specific changes in ArcSDE 9.1 improve its performance with Oracle Spatial?

Question

What specific changes in ArcSDE 9.1 improve its performance with Oracle Spatial?

Answer

1- At ArcSDE 9.1, read-time validation was removed for Oracle Spatial feature classes, the only storage type that used read-time validation. This issue only affects users that create or modify features in ArcSDE SDO_GEOMETRY feature classes with non-ESRI applications or with SQL. Data created with any ArcSDE client application are validated when written to the feature class, and therefore don't need to be validated again.

We recommend that users who add or change features with SQL or third-party applications should validate the feature classes using use 'sdelayer -o feature_info'. Using invalid features with ArcSDE client applications, including ArcGIS, may cause unexpected results. This change will improve performance for all users of Oracle Spatial feature classes.

2- There are reduced differences in SQL among users in common ArcSDE operations. This enhances performance for multiple users sharing the same server.