Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Analyze and backup question
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.
Received on Wed Aug 25 1999 - 09:14:18 CDT