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 -> NewBie question: 9i query runs slower than same query on 8i?

NewBie question: 9i query runs slower than same query on 8i?

From: <paulhux174_at_hotmail.com>
Date: 28 Aug 2005 17:35:53 -0700
Message-ID: <1125275753.355336.156620@o13g2000cwo.googlegroups.com> 





I've a Oracle 9i db installed on a server elsewhere.
I've a program that runs a query using ODBC.



I installed oracle 8i (OraHome8i ODBC) on my machine and run the
program - works fine.



I then install oracle 9i on my machine. then run the program using the
9i driver (OraHome9i ODBC)and the query takes about 5 times as long.
The query hasn't changed.



What do I need to change in 9i setup or configuration to get it to run
the same as 8i.
Received on Sun Aug 28 2005 - 19:35:53 CDT












Original text of this message













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