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: query's explain plan different in 8i and 9i?

Re: query's explain plan different in 8i and 9i?

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 22 Oct 2003 15:27:02 +0100
Message-ID: <3f9693b7$0$251$ed9e5944@reading.news.pipex.net> 





"Brian Peasland" <dba_at_remove_spam.peasland.com> wrote in message
news:3F96825A.AC52C29A_at_remove_spam.peasland.com...


> Just goes to show that the parameters can have a difference on the CBO

> between versions.



and indeed that 'all parameters are the same' is an easy statement to make,
but often not true even if the parameter file is unchanged.



-- 
Niall Litchfield
Oracle DBA
Audit Commission Uk


Received on Wed Oct 22 2003 - 09:27:02 CDT












Original text of this message













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