I'm running a ArcGIS 9.3 Oracle SDE geodatabase. Our ArcMap client is extremely slow at displaying versionned feature class. One table seems to be impacted : sde.state_lineages A simple SELECT * FROM sde.state_lineages takes more than 10 seconds to display 69 rows. Any idea what could be the problem?

  • You've got an ancient database, and ancient geodatabase metadata. The table is probably massively fragmented. One of the benefits of keeping up with software upgrades is the occasional platform change, which resets the high water mark for all tables, shrinking them to the minimum number of extents necessary to hold the table. Unfortunately, you're nearly at the point that the highest supported upgrade path is also in Retired status, so you'll be working at the database level without a net. I'd recommend you make an extra backup before proceeding. – Vince Jul 5 '18 at 11:35
  • I know this is stone age ArcGIS version but my client has not yet moved to 10.x. – vegemat Jul 5 '18 at 12:58

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.