Re: Oracle 8i performance problem since Migration

On Mon, 28 Jul 2003 20:07:17 GMT, Brian Peasland <dba_at_remove_spam.peasland.com> wrote:

>One of the most common things that people forget after an upgrade is to
>recompute statistics. This may be applicable to your case. You'll also
>want to take a look at any CBO-relevant INIT.ORA parameters.
>
>HTH,
>Brian
>
>rfbas wrote:
>>
>> Hi,
>>
>> Since our migraion from oracle 8.0.5 to oracle 8i we have serious
>> performance problems. I dont see any thing !
>>
>> Could some one tell me the reasons that could cause this problem ?
>>
>> Or what do i have to check ?
>>
>> Or at least tell me were can i find documents on migration problems ?
>>
>> Thank u

I agree - I also found after the upgrade from 8 - 8i, the optimizer was a lot touchier with regards to the degree of parallel set on various tables. Took a bit of tinkering before things settled down again. Received on Mon Jul 28 2003 - 20:16:41 CDT