Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
![]() |
![]() |
Home -> Community -> Usenet -> c.d.o.server -> Re: NewBie question: 9i query runs slower than same query on 8i?
paulhux174_at_hotmail.com wrote:
> 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.
Could be any one of a few dozen things such as but not limited to:
To start with run an explain plan in both.
-- Daniel A. Morgan http://www.psoug.org damorgan_at_x.washington.edu (replace x with u to respond)Received on Sun Aug 28 2005 - 20:07:07 CDT
![]() |
![]() |