Re: Potential Oracle Bug: SQL query hangs

From: Bib Endum <gd-newsgroups_at_spamex.com>
Date: Fri, 5 Mar 2004 09:14:18 -0500
Message-ID: <7X%1c.9075$jw2.616193@news20.bellglobal.com>

"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

Received on Fri Mar 05 2004 - 08:14:18 CST