Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> RE: ORACLE 10gr2 collect statistics on sys and system?

RE: ORACLE 10gr2 collect statistics on sys and system?

From: Christian Antognini <Christian.Antognini_at_trivadis.com>
Date: Fri, 16 Jun 2006 10:47:05 +0200
Message-ID: <F2C9CCA71510B442AF71446CAE8AEBAF3F5FD4@MSXVS04.trivadis.com> 





Hi



>I just don't understand why 10Gr2 need collect

>statistics on "sys", but 9ir2 don't need.




In 10g the RBO is no longer supported. Therefore Oracle had to switch to the CBO as well.




HTH



Chris


--
http://www.freelists.org/webpage/oracle-l


Received on Fri Jun 16 2006 - 03:47:05 CDT












Original text of this message













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