Is it possible to configure the Database Agent to use a DEDICATED Server instead of the default SHARED Server for the connection to an Oracle database?
This would be similar to the tnsnames.ora equivalent of (SERVER=DEDICATED) vs SERVER=SHARED).
There is a known Oracle bug when using shared server on a RAC environment. Also an overload situation could happen, that the database ran out of shared server processes.
The Oracle agent has no option to switch between as shared or dedicated service process connection.
Best practices would be to follow Oracle and apply the fix Oracle might suggest.
In case of an overload where the database ran out of shared server processes (very rarly) please increase the amount of allowed processes.
© ALL RIGHTS RESERVED. Feedback Terms of Use Privacy Cookie Preference Center