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: SQL query time out in ORACLE db

Re: SQL query time out in ORACLE db

From: Jim Smith <jim_at_jimsmith.demon.co.uk>
Date: Fri, 23 Sep 2005 19:19:54 +0100
Message-ID: <Vg8B+ueKdENDFw$g@jimsmith.demon.co.uk>


In message <1127491886.694839.223400_at_f14g2000cwb.googlegroups.com>, gilroy.ponniah_at_gmail.com writes
>Hi David,
>
>You are absolutely correct. We talk about it too. However, ACCPAC is
>a small medium accounting package used by millions of people around the
>world. Unfortunately I work as Consultant for a solution provider.
>ACCPAC runs on ORACLE, SQLServer, DB2 and Pervasive database servers.
>
>I rename the column to 'VALUE1' and tried the same query with
>'VALUE1' as column name and got the same behavior with no result. Any
>other suggestions???

Try investigating. Run explain plan and post it here.

-- 
Jim Smith
Because of their persistent net abuse, I ignore mail from
these domains (among others) .yahoo.com .hotmail.com .kr .cn .tw
For an explanation see <http://www.jimsmith.demon.co.uk/spam>
Received on Fri Sep 23 2005 - 13:19:54 CDT

Original text of this message

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