nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

ArcGIS Enterprise / Oracle EGDB: ArcGIS Server creates a lot of extproc processes on database server

MartinF

The ArcGIS Pro manual (see https://pro.arcgis.com/en/pro-app/2.9/help/data/geodatabases/manage-oracle/configure-oracle-extproc.htm) says :

But even if st_shapelib and extproc are not configured at all, the ArcGIS Server services create extproc processes on the database server. How is this to be explained ...

... and why do they grow so rapidly during operation. In our customer’s environment ArcGIS Server produces extproc processes of exorbitant size which finally crash the database server:

Any idea (helping to understand) would be great!

@George_Thompson ?

Regards,
Martin

Trouver plus de publications taguées avec

Enterprise geodatabase

Services

Accepted answers

All comments

George_Thompson

I have not seen that happen before. I would recommend contacting Esri tech support to work on this.

Sounds a little weird.

MartinF

... and for these points it is possible that the extproc processes grow rapidly to a lot of gigabytes?

And the st_shapelib is not configured for extproc.ora in the EGDB!

rkrisher

My guess is that one or more of their feature services / web maps are performing 2 or 4. If you have a staging environment you should be able isolate the issue to a specific service or map that is behaving badly. If you are unable to reproduce using just the feature services, then one or more of your users may be performing items 1, 3, and/or 5.

MartinF

Nothing from the listed operations, they are just using referenced feature
services from the Oracle EGDB in a multiple machine deployment (with mobile
offline editing)

MartinF

1) No other Enterprise Geodatabases on that Oracle server

And

2) My own test environment where no one else is connected to the database.
If I start or stop the services with ArcGIS Server Manager the extproc
processes on the database server appear or disappear

George_Thompson

I have not seen that before. Are there any other Enterprise Geodatabases on that Oracle server?

How are you determining that the ArcGIS Server service is utilizing the Oracle extproc process?

rkrisher

Can you provide information about your workflow and what your customer is doing? Which of the operation(s) listed in the help are they performing when you are experiencing this behavior?

Rejoindre la conversation

Les membres connectés peuvent publier, suivre les mises à jour, et plus encore. Nouveau ici ? Inscrivez-vous gratuitement.

Se connecter
S'inscrire

Liens rapides

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.