Database Administration (MOSC)

MOSC Banner

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.

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center