oracle 9.0.1.5 windows handle leak ?

From: mokk <iip0_at_mail.ru>
Date: Fri, 11 Sep 2009 09:34:55 -0700 (PDT)
Message-ID: <250e6858-bd96-4330-8b5a-bbf77347a7a5_at_y21g2000yqn.googlegroups.com>

some time ago i noticed that one of new 9.0.1.5 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 10.2.0.3.Situation may be reproduced so

1. at oracle 9.0.1.5 create user TEST1 identified by "test"; grant connect to TEST1; grant resource to TEST1;

create or replace procedure test1.empty1 is begin
  null;
end;

2)at oracle 10.2.0.3
--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
begin
  empty1_at_ora90tmp;
end call1;

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

3)calling call2 adds to db 9.0.1.5 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