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:

1. 9i database configuration
2. Optimizer statistics created with DBMS_STATS
3. Differences in data such as cardinality and number of rows
4. Differences in indexes
5. Not enough memory to support 9i
6. 8i ODBC driver
7. Poorly set or default configurations in pfile

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)