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

Re: Determine wich procedure is used to update optimiser statistics

From: Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl>
Date: Wed, 25 Feb 2004 22:11:29 +0100
Message-ID: <7r3q30djc85nn5jqo9dn4ftthoctad2nj1@4ax.com> 





On 25 Feb 2004 09:19:55 -0800, rjp.l_at_laposte.net (rjp) wrote:



>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




Oracle doesn't keep track of that.



--
Sybrand Bakker, Senior Oracle DBA


Received on Wed Feb 25 2004 - 15:11:29 CST












Original text of this message













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