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

> One is Oracle 8i ... one is Oracle 9i.
>
> What isn't different?

Well if he was accessing two different remote dbs on two different versions, then everything could be different, of course. I can only keep responding to what I was trying to say in my previous post.

>>> 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 do your comments relate to two different *client* installations?

Even if the OP has installed two completely different RDBMS versions on his local machine to access the same remote database, how is he going to get different execution plans, init parameters etc?

--
Doug Burns - Oracle DBA

dougburns_at_yahoo.com

http://doug.burns.tripod.com
http://oracledoug.blogspot.com