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: Performance problem

Re: Performance problem

From: Paul <paul_at_see.my.sig.com>
Date: Wed, 07 Dec 2005 19:05:51 +0000
Message-ID: <a6cep1l6br0f7c9o6ocf728nsgg71i6usl@4ax.com>

"hpuxrac" <johnbhurley_at_sbcglobal.net> wrote:

> # Change them back and see does this have any effect.
 

> No sorry but you are on the completely wrong track here.
>
> The OP is already in trouble. Following a methodology is the correct
> recommendation at this point. Please see my reply in this thread.

And I am suggesting a methodology. Look at the cards first (separately), the disks (separately) and disk layout(s) separatlely.

That seems to me to be a fairly logical way to go about tackling the problem at hand - if, say, the disk change alone corresonds to 95% of the extra time, then you've found your culprit.  

> Experimenting with further changes and/or "backing out" some or all of
> the recent changes is exactly "what not to do".
> Shooting in the dark is not recommended.

I agree that farting around randomly with extra changes is essentially pissing into a Katrina - however reversing the changes made one by one and separately is *_one_* reasonably good way of trying to find out where the problem lies. BTW, I'm not denying the value of your approach, I'm just saying that mine is not invalid. I would also agree that your approach my turn up solutions not even imagined by the OP.  

> Paul if you haven't read Cary's book please take the time to do so.

The first day I start working on a decent Oracle system, it's one of the first on my list.

Paul...

-- 

plinehan __at__ yahoo __dot__ __com__

XP Pro, SP 2, 

Oracle, 9.2.0.1.0 (Enterprise Ed.)
Interbase 6.0.1.0;

When asking database related questions, please give other posters 
some clues, like operating system, version of db being used and DDL.
The exact text and/or number of error messages is useful (!= "it didn't work!").
Thanks.
 
Furthermore, as a courtesy to those who spend 
time analysing and attempting to help, please 
do not top post.
Received on Wed Dec 07 2005 - 13:05:51 CST

Original text of this message

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