Re: terminating a recursive PL/SQL loop

Thank you for your advice, but this does not help. After submitting a "kill session" for the session with the endless recursion, that session is only marked for kill, but the process is still running and allocating memory on the server.

I found in the manuals the error message "PL-00996 out of memory", which should be fired if a recursion is to deep. That perhaps would help to solve my problem, but I don't get this error. Instead of getting that error the memory usage of the "oracle73" process grows dramatically until the NT machine is out of virtual memory. Do you know a initialization parameter, which limits the the PL/SQL stack size or the maximum memory usage of the Oracle-Instance?

Arno Tigges.

Oracleguru wrote:

> Hi
>
> See if this will helps.
>
> First, run this script and get sid and serial#:
>
> set wrap on pause off
> alter session set nls_date_format = 'dd-MON-yyyy hh24:mi:ss';
> select username, osuser, terminal, program, machine, logon_time,
> sid, serial#
> from v$session;
> exit
>
> Then, use the script below to kill the session:
>
> alter system
> kill session ' &SID, &SERIAL_NO'
> /
>
> Oracleguru
> www.oracleguru.net
> oracleguru_at_mailcity.com
Received on Fri Aug 28 1998 - 06:22:01 CDT