Very slow performance on adding global ID

[Anonymous User]

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

[anthonysanchez]

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