Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> Re: Analyze and backup question
You didn't say if the cold backup was file or exp/imp. If exp/imp, did
you include statistics in the export so that import will recalculate them.
HTH
tED
ronb1234_at_my-deja.com wrote in message <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 - 15:19:05 CDT