Re: help

From: Richard Nield <richard.nield_at_ntlworld.com>
Date: Sun, 9 Feb 2003 18:40:29 -0000
Message-ID: <ugx1a.1372$mH4.975_at_newsfep1-gui.server.ntli.net>


[Quoted] [Quoted] Thanks. Is this something our DBA should have made us aware of?

"DA Morgan" <damorgan_at_exesolutions.com> wrote in message news:3E46899D.E7BEC1FD_at_exesolutions.com...
> Sybrand Bakker wrote:
>
> > On Sun, 9 Feb 2003 12:41:37 -0000, "Richard Nield"
> > <richard.nield_at_ntlworld.com> wrote:
> >
> > > What can I tell him?
> >
> > - dbms_stats provides more accurate statistics
> > - it can use multiple processors
> > - you can set it up such you only need to calculate stale statistics.
> >
> > But of course I am abstracting the manual now, so I will leave it at
> > this few lines.
> >
> > Sybrand Bakker, Senior Oracle DBA
> >
> > To reply remove -verwijderdit from my e-mail address
>
> In addition DBMS_STATS works with all of the new features added with 8i
> and 9i such as partitioned tables and indexes. Unless you are working
> with 7.x or 8.0 object types only this is important.
>
> Go to http://tahiti.oracle.com to find documentation on this package.
>
> Daniel Morgan
>
Received on Sun Feb 09 2003 - 19:40:29 CET

Original text of this message