Re: help

Richard Nield wrote:

> 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
> >

Only if your DBA has an investment in staying current with the state of Oracle recommendations and technology.

Ask the following questions of your DBA
1. Are we using dictionary managed or locally managed tablespaces? 2. What is the difference in 9i between rollback segments and undo?

The answers will let you know whether they are keeping up or stagnating.

Daniel Morgan Received on Sun Feb 09 2003 - 22:22:52 CET