topic Re: Slow identifying ArcSDE layer - Oracle tablespace issue in Data Management Questions

Slow identifying ArcSDE layer - Oracle tablespace issue

ChrisBuckmaster1 — Thu, 16 Feb 2012 14:27:31 GMT

Hi

I found that when querying an ArcSDE feature class it was taking a long time to return the results (much longer than usual); I could also not update the attributes.

It was discovered that there was not enough space left in the Oracle tablespace so it was put onto autoextend.

I can now alter the attributes but it still appears very slow when identifying features in ArcMap.

Do I also need to restart the server / do something within ArcSDE?

Thanks

Re: Slow identifying ArcSDE layer - Oracle tablespace issue

VinceAngelo — Thu, 16 Feb 2012 15:16:43 GMT

There's probably a lot of interrelated things going on here.

AUTOEXTEND is a datafile property (tablespaces reside in one or more datafiles,
and tables [or their partitions] are assigned to tablespaces). This would have an
impact on not being to add rows (if the tablespace storage had been exhausted),
but not on query, per se.

There's probably dozens of things that can be done to improve query performance,
but the order in which they should be attempted depends on the answers to these
questions:
+ What geometry storage is being used (ST_GEOMETRY, SDO_GEOMETRY, SDELOB,
SDEBINARY)?
+ Is your table versioned?
+ Have you used DBTUNE keywords to distribute the table(s) and LOBs across
tablespaces?
+ How many rows in your business table?
+ If versioned, how many rows in your adds and deletes tables?
+ If versioned, when was the last time you did a compress?

- V

Re: Slow identifying ArcSDE layer - Oracle tablespace issue

ChrisBuckmaster1 — Fri, 17 Feb 2012 07:28:50 GMT

Hi Vince

Thanks for your response - our issues seems to have resolved itself overnight.