Re: oracle 9.0.1.5 windows handle leak ?

Max Handles values for Win2003 ?
> Amount of memory + architecture type. In x32 it is dword, i.e., 4
> milliards.

-> not real issue

"mokk" <iip0_at_mail.ru> wrote in message news: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 Tue Sep 15 2009 - 03:21:45 CDT