Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Determine wich procedure is used to update optimiser statistics
ok
Thank for your help
rjp
Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in message news:<7r3q30djc85nn5jqo9dn4ftthoctad2nj1_at_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.
Received on Thu Feb 26 2004 - 03:21:40 CST