Re: Potential Oracle Bug: SQL query hangs

"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