oracle windows handle leak ?

From: mokk <>
Date: Fri, 11 Sep 2009 09:34:55 -0700 (PDT)
Message-ID: <>

some time ago i noticed that one of new database process has high handle count as reported by taskmgr.Number is growning steadily and some day db will crash or system will be unstable because of kernel pool shortage.Database was accessed by dblink from other db oracle may be reproduced so
  1. at oracle create user TEST1 identified by "test"; grant connect to TEST1; grant resource to TEST1;

create or replace procedure test1.empty1 is begin

2)at oracle
--connect any user with privilege connect,resouce,create db link create database link ORA90TMP connect to TEST1 identified by test1 using 'ora90tmp';

create or replace procedure call1 is
end call1;

create or replace procedure call2 is
i integer;
for i in 1..1000 loop
  dbms_session.close_database_link('ORA90TMP');   commit;
end loop;
end call2;

3)calling call2 adds to db oracle.exe ~ 1000 handles.They dont go away after disconnect;

at this example handles mostly \device\afd (network device ?),but on real system it was mostly oraus.msb Received on Fri Sep 11 2009 - 11:34:55 CDT

Original text of this message