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: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Mon, 28 Jul 2003 20:46:11 +0100
Message-ID: <3f257d82$0$11385$cc9e4d1f@news.dial.pipex.com>


"rfbas" <rfbas_at_wanadoo.fr> wrote in message news:bg3lao$imm$1_at_news-reader3.wanadoo.fr...
> 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 ?

0. gather stats
1. identify what processes are suffering.
2. measure what they are doing with tracing (statspack or event 10046).
3. see what takes the time.
4. tune it. (think missing stats,missing index, bad sql).
5. repeat.


-- 
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Mon Jul 28 2003 - 14:46:11 CDT

Original text of this message

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