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:52 -0700
Message-ID: <1125332461.815253@yasure>

Doug wrote:
> DA Morgan wrote:
>

>>>Thanks for you responses, but
>>>The Oracle database hasn't changed, it still is the same db running on
>>>the same remote server( not local on my machine).
>>
>>
>>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.
>>

>
>
> How is it a completely different database by definition when the OP has
> stated that the only thing that's changing here is the client ODBC
> installation? Same query, same (remote) database, just a different
> client installation ...
>
> I'm confused.
> --
> Doug Burns - Oracle DBA
>
> dougburns_at_yahoo.com
>
> http://doug.burns.tripod.com
> http://oracledoug.blogspot.com

One is Oracle 8i ... one is Oracle 9i.

What isn't 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:52 CDT