Limit Spatial Index

761
5
01-07-2014 07:49 AM
ClovesAntonio1
New Contributor
Hi,

We have an application in ArcGIS 10 platform that uses spatial indexes.
The indices of this application to a particular region had its boundaries changed 9.2km to 90km.

This asks from is if we have a limit to establish the change of indices so that does not cause problems in the performance
of the database.

Cloves Antonio
CGI Brasil
0 Kudos
5 Replies
VinceAngelo
Esri Esteemed Contributor
It's nearly impossible to answer a question with so few details correctly --

  • In what format is the data stored?

  • If it's a ArcSDE geodatabase, in which RDBMS?

  • What geometry format is in use?

  • How did you change the boundaries of indicies in an application?

Generally speaking, significant changes to data require systematic reconstruction
of all indexes (though sometimes they also require reloading of the table itself
to eliminate the impact of fragmentation, then reconstruction of all indexes).

- V
0 Kudos
ClovesAntonio1
New Contributor
Vangelo,

1) If it's a ArcSDE geodatabase, in which RDBMS?
ArcSDE 10 with RDBMS Oracle 10g

2) What geometry format is in use?
Feature class

3) How did you change the boundaries of indicies in an application?
The user execute the following steps:
1) Select the area you want to move
2) Moviment 90km to the selected region.
Problem: This movement this generating a consumption of 20% of use of memory usage to only one user. The concern is when we have 100 concurrent users if the infrastructure to meet this movement.

Generally speaking, significant changes to data require systematic reconstruction of all indexes (though sometimes they also require reloading of the table itself to eliminate the impact of fragmentation, then reconstruction of all indexes).

Cloves Antonio
0 Kudos
VinceAngelo
Esri Esteemed Contributor
The geometry storage options for Oracle are: ST_GEOMETRY, SDELOB, and SDO_GEOMETRY.

I do not understand your description.  Are you saying you moved a feature to a different
location in the envelope?  A change in memory usage makes no sense in this context (unless
you're using an early 10gR2, like 10.2.0.1, which isn't supported at all).

You should probably speak with your local Tech Support office.

- V
0 Kudos
ClovesAntonio1
New Contributor
Vangelo,

I´m sorry.
Ours  problem this in relation the use of memory on server of application.
When the user select one area the area this is sent to memory of server.
After, the move user this area to one new region with at 90km.
The number of data this area is very big and the memory of server not this supporting.

The question is if change of memory of server, but think than the problem continuing
OR
If we create one limit in range of grid spatial index the problem are resolved.

Version Oracle Used: 10.2.0.5 64 bits

Cloves Antonio
CGI Brasil
0 Kudos
VinceAngelo
Esri Esteemed Contributor
I'm sorry, but  still don't understand the issue.  What does "one limit in range of grid spatial
index" mean?

What does 'sdelayer -o describe_long' report for the layer?

Oracle 10g is very old, and while technically supported by Oracle, it's difficult to reproduce
errors on on database no one uses any more.

- V
0 Kudos