Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Oracle 8i performance problem since Migration

Re: Oracle 8i performance problem since Migration

From: Brian Peasland <dba_at_remove_spam.peasland.com>
Date: Mon, 28 Jul 2003 20:07:17 GMT
Message-ID: <3F258275.31A5FD63@remove_spam.peasland.com>


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

-- 
===================================================================

Brian Peasland
dba_at_remove_spam.peasland.com

Remove the "remove_spam." from the email address to email me.


"I can give it to you cheap, quick, and good. Now pick two out of
 the three"
Received on Mon Jul 28 2003 - 15:07:17 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US