Re: [Q] How can I prevent infinite loop?

From: Vsevolod Afanassiev <vafanassiev_at_westpac.com.au>
Date: Mon, 20 Sep 1999 17:04:53 +1000
Message-ID: <7s4mb8$g8m4@xlprod01.westpac.com.au>

There is no infinite loop in Oracle unless you wrote one using PL/SQL... If a statement takes extraordinary amount of time to execute it may be because:

1) You forgot a condition in WHERE clause
2) database does not using index
3) The tables are just big
4) many other reasons including high load on the box, contention for the

disk drive, chained rows, etc

Try to analyze the tables, look at the number of rows, simplify the query, etc.

Regards,
Sev

Connor McDonald wrote in message <37E2EFE5.1ECB_at_yahoo.com>...
>¹Ú³ëö wrote:
>>
>> Hello. I'm developing 3-tier WebApp using Oracle 8.0.4 on NT
>>
>> By the way, I send Oracle certain SELECT statement, sometimes
>> it doesn't response. In this situation, how can I distinguish whether
>> it is retreiving data from table(there's so many data to dig) or fell
>> into infinite loop?
>>
>> In case of infinite loop, is it possible to abort the process and retuen
>> error message to MTS Component or something that throws the SQL
>> statement, by setting SQL_TIMEOUT or something like that?
>>
>> Thanks in advance.
>
>Take a look at profiles - you can set the maximum amount of resource
>that an account can use before its gets killed...
>
>
>--
>===========================================
>Connor McDonald
>"These views mine, no-one elses etc etc"
>connor_mcdonald_at_yahoo.com
>
>"Some days you're the pigeon, and some days you're the statue."
Received on Mon Sep 20 1999 - 02:04:53 CDT