Process handle not drop after execution

From: Billy Angers <billy.angers_at_cegeptr.qc.ca>
Date: Fri, 13 Dec 2002 16:59:51 GMT
Message-ID: <bmoK9.8535$eO3.103567_at_charlie.risq.qc.ca>

We launch from the DB a Java procedure that run a shell script on the server. In the Process explorer on the server, the process goes on but when he's finished and successfully executed, the handle generated by what he launched still alive on server.

Exemple

Oracle.exe                    (100)
    -CMD.exe                (150)
            -Sqlplus.exe      (155)

Process with handle 150 is set to unrecognized mode and he doesn't free the handle.
When starting whe get about 350-400 handles used, but one DB have reach 14000 handles.
An other have been restarted and 3 hours later, it as reach 750 handles. The only way we've found to clean this up, is to restart the DB.

Anyone could help me on that

P.S. French answer would be great if possible.

Billy Angers Received on Fri Dec 13 2002 - 17:59:51 CET