utl_http and utl_tcp Leak udp Connections When Run From a Job

(Doc ID 367420.1)

Last updated on APRIL 05, 2010

Applies to:

Oracle Server - Enterprise Edition - Version:
Information in this document applies to any platform.


Running utl_http or utl_tcp structures from inside a job can leak udp connections at each run.
The situation appears after installing the 9207 patchset

To see if the issue is occurring from a system, the following can be done:
+ run test_http procedures from inside a job every 4 seconds
+ check the udp connections number using:

lsof -i | grep UDP


At every job run the number of udp connections is seen as increasing.


Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms