Re: Performance problem

"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.