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: Doug <dougburns_at_yahoo.com>
Date: 29 Aug 2005 02:01:16 -0700
Message-ID: <1125306075.993836.299530@f14g2000cwb.googlegroups.com>


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
Received on Mon Aug 29 2005 - 04:01:16 CDT

Original text of this message

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