Re: Analyze and backup question

No, it's the same init file. It's possible it could be buffer cache, but I will have to do some more testing to confirm this.

Thanks

Ron Bogdanoff

In article <935591530.26822.0.nnrp-07.9e984ad0_at_news.demon.co.uk>,   "Brian McCabe" <brian_at_nospam.mccabe.org.uk> wrote:
> A cold backup won't change the statistics. The only thing I can think
of is
> that the performance drop is due to the buffer cache being flushed by
the
> instance reboot. You aren't switching init.ora files on restart or
anything
> like that are you?....
>
> <ronb1234_at_my-deja.com> wrote in message
news:7pv0nm$ghf$1_at_nnrp1.deja.com...
> > Hi,
> >
> > Has anyone seen this before?
> >
> > I have a database that has been analyzed so I can use cost based
> > optimization. Everything works fine after I analyze the schema.
> >
> > However, If I do a cold backup of the database that has just been
> > analyzed and then restore it, I get very poor performance unless I
> > analyze it again.
> >
> > If I do an analyze and don't backup/restore the performance is
normal.
> >
> > What would a cold backup/restore do to effect the statistics of an
> > analyze?
> >
> > This is Oracle 8.1.5 on NT
> >
> >
> > Sent via Deja.com http://www.deja.com/
> > Share what you know. Learn what you don't.
>
>

Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Wed Aug 25 1999 - 12:10:03 CDT