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: 9.2.0.7
Information in this document applies to any platform.

Symptoms

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.

Cause

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