Resourcemanager and external procedure
Hi,
we have an application running (ArcGIS) which needs an external procedure library which was copied on all of our RAC-DB cluster nodes. Within this library a package for spatial query is created. I'm not happy about this, but I've had no choice:
We have limit in CDB resource manager plan the CPU for this PDB.
My question is:
If a SQL-query uses this external procedure you see a "extproc" process on the cluster. What happens if this "extproc" process consumes very high CPU. Does the Oracle Resource Manager limit the CPU for this "extproc" process calling consumer group. I would say "no" because it is an external OS-process as other. If "yes" I'm happy about this behavior.