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

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

From: DA Morgan <damorgan_at_psoug.org>
Date: Mon, 29 Aug 2005 09:21:02 -0700
Message-ID: <1125332411.640883@yasure>


Matthias Kleinicke wrote:
> Hello,
>
> DA Morgan schrieb:
>

>> Wrong answer ... it is a completely different database by definition.
>> Different data dictionary, different system tablespace, different
>> rollback/undo tablespace, different temp tablespace, hopefully a
>> different tablespace type, definitely different initialization
>> parameters.
>>

> > [...]
>
>>
>> The one in your head. You've been given excellent advice. Follow it or
>> YOYO. Without Explain Plans there is nothing more we can do to help you.

>
> Did I take it right there are differeces adressing a database via
> different versions of ODBC-driver? meaning not only support of extensions?
>
> Matthias

Of course. But missing the point ... Oracle 8i and 9i are different: Very very different.

-- 
Daniel A. Morgan
http://www.psoug.org
damorgan_at_x.washington.edu
(replace x with u to respond)
Received on Mon Aug 29 2005 - 11:21:02 CDT

Original text of this message

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