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

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

Potential Oracle Bug: SQL query hangs

From: Andre van Eyssen <nntempt_at_purplecow.org>
Date: Fri, 5 Mar 2004 05:37:13 +0000 (UTC)
Message-ID: <c293m9$p1e$1@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





Any information would be appreciated.



-- 
Andre


Received on Thu Mar 04 2004 - 23:37:13 CST












Original text of this message













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