Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Potential Oracle Bug: SQL query hangs

Re: Potential Oracle Bug: SQL query hangs

From: jim caprioli <jim.cp_at_zonnet.nl>
Date: Sun, 11 Apr 2004 06:27:44 +0200
Message-ID: <opr59yoijti17tql@News.individual.NET>


Shouldn't you report this to Oracle??? (They will tell you that it is fixed in 9 upwards though, have you considered u p g r a d i n g ? )

On Fri, 5 Mar 2004 09:14:18 -0500, Bib Endum <gd-newsgroups_at_spamex.com> wrote:

>
> "Andre van Eyssen" <nntempt_at_purplecow.org> a écrit dans le message de
> news:c293m9$p1e$1_at_mws-stat-syd.cdn.telstra.com.au...
>> Hi all,
>>
>> Oracle Version: 8.1.7.4
>> OS: Tru64 V5.1B
>>
>> The problem is roughly:
>>
>> This query hangs, leaving the Oracle process eating CPU and doing
>> nothing
>> useful.
>>
>> Query: select POWER(DECODE(52725,0,0,16340/52725),059) from dual
>> Session Wait Event: SQL*Net Message to Client
>
> FYI: Instant reply on 8174 solaris 2.6
>
> SQL> select POWER(DECODE(52725,0,0,16340/52725),059) from dual;
>
> POWER(DECODE(52725,0,0,16340/52725),059)
> ----------------------------------------
> 9.6137E-31
>
>

-- 
http://NiLOSTEP.com/
Received on Sat Apr 10 2004 - 23:27:44 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US