Re: Oracle statistics

Thank You all the the information
I really don't want to drop all the tables and recreate them, but is not my say, this is for a client and they the database like this, also I have discoverded that they are useing a share device in which the database is writing at the same time to the same device as the fail over server, in which I can now point to this beeing the problem. I just took over this database position 2 weeks ago, therefore I'm lacking lost of history e.g. in how wsa set up, etc.... Thanks for your help

Maria

"Richard Foote" <richard.foote_at_bigpond.com> wrote in message news:<cR0g9.30581$g9.87835_at_newsfeeds.bigpond.com>...
> Good morning Niall,
>
> Hey, you watch my back and I'll watch yours ;)
>
> Richard
> "Niall Litchfield" <niall.litchfield_at_dial.pipex.com> wrote in message
> news:3d804f60$0$1285$cc9e4d1f_at_news.dial.pipex.com...
> > "Richard Foote" <richard.foote_at_bigpond.com> wrote in message
> > news:ZSWf9.30156$g9.86970_at_newsfeeds.bigpond.com...
> > > 2) Look at using DBMS_STATS rather than analyze, pick an appropriate
 sample
> > > size (you haven't mentioned DB version but note 9i has some nice options
> > > with this) and consider running in parallel, which is one of the
 advantages
> > > of this package.
> >
> > Oops I intended to mention this but seem to have got hung up on some other
> > concern with the drop/recreate thingy :(. Good catch Richard.
> >
> >
> > --
> > Niall Litchfield
> > Oracle DBA
> > Audit Commission UK
> > *****************************************
> > Please include version and platform
> > and SQL where applicable
> > It makes life easier and increases the
> > likelihood of a good answer
> > ******************************************
> >
> >
Received on Thu Sep 12 2002 - 14:31:14 CDT