Very slow performance on adding global ID

Anonymous User — Wed, 06 Mar 2013 08:08:13 GMT

Original User: Ameskamp

Hi,

we have a largish SDE-Database (various FCLs with millions of ST_GEOMETRY features) on ArcSDE 10.5, Oracle 11.2.0.3, running on WS 2008 R2 physical machine with local disk.

We're trying to add global IDs before duplicating the database with expdp/impdp and setting up geodatabase replication. We're using the ArcCatalog context menu on a feature dataset, and performance is simply terrible:

Adding global IDs to a single FCL of about 2.4 mio features takes over 2 hours. Looking at Oracle AWR, I see that the actual update statement on the FCL takes about 4 minutes of CPU time, there is no significant activity either on the client or database server, Oracle writes about 300 KB/s, the whole system, including the ArcCatalog process, is basically idle.

Any idea what's going on here?

Thanks very much, Martin

Re: Very slow performance on adding global ID

anthonysanchez — Thu, 07 Mar 2013 12:31:25 GMT

Hi,
A level 12 trace of about 5-10 minutes of the action may prove useful in seeing exactly where all the time is being spent. I'd start there and post a tkprof of the trace (keep the raw a available just in case).

Anthony

topic Very slow performance on adding global ID in Data Management Questions

Very slow performance on adding global ID

Re: Very slow performance on adding global ID