Re: Endless loop kill the server?

Hi,
 test, test, code review.
 perhaps you can put quota on ressources like disk I/O, cpu cycles etc.  this does not work with all systems, e.g. it might kill a daemon after a couple of weeks or a process that _is_ supposed to take a lot of resources.

Karsten

In article <8amgsf$rv$1_at_netnews.upenn.edu>, ming_at_sol1.lrsm.upenn.edu (Ming Luo) wrote:
> I have a test Oracle system running on a NT. The following procedure
 eats
> up 100% cpu power of NT. I could only get out of the SQL envirement by
> killing the session. Could somebody please enlighten me how to prevent
> such kind of problem to do harm to the oracle system? Thanks.
>
> ===========================================================
> create or replace procedure testo is
> cursor geto is select * from test;
> rr test%rowtype;
> begin
> open geto;
> loop
> fetch geto into rr;
> --exit when geto%notfound; -- without this line it executes forever
> end loop;
> end;
> /
>
>

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 15 2000 - 00:00:00 CST