we have a largish SDE-Database (various FCLs with millions of ST_GEOMETRY features) on ArcSDE 10.5, Oracle 126.96.36.199, 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.
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).