Very slow performance on adding global ID

03-06-2013 12:08 AM
by Anonymous User
Not applicable
Original User: Ameskamp


we have a largish SDE-Database (various FCLs with millions of ST_GEOMETRY features) on ArcSDE 10.5, Oracle, 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
0 Kudos
1 Reply
New Contributor III
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).

0 Kudos