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 -> Determine wich procedure is used to update optimiser statistics

Determine wich procedure is used to update optimiser statistics

From: rjp <rjp.l_at_laposte.net>
Date: 25 Feb 2004 09:19:55 -0800
Message-ID: <9b7a7215.0402250919.5fc91e52@posting.google.com> 





Hi,



How could I determine the way of statistics update is used for a 9iR2
production database ?


I have performance problems and I don't know if the statistics are
updates by 'DBMS_UTILITY.SCHEMA' or 'analyze table' or
'DBMS_STATS'(the last one seems to be preferable to the two others
way).



TYIA



RJP

Received on Wed Feb 25 2004 - 11:19:55 CST












Original text of this message













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