Re: Performance : Need better performing Oracle!!!

Hi

To do the job you need CPU resources and IO resources. From your description, IO is the main problem, and CPU accounts for only 150/400 = 37% of the total time. It makes more sense to look at the IO problem. An idea is more memory and larger Oracle SGA.

But to answer your questions:
1 Without addressing the IO problem, you should expect something like 4.5 hours overall time, i. e. only modest reduction 2 If you eliminate all the IO bottlenecks and use an N4000/8 you should be able to run step 3 in less than an hour

If this is still not fast enough, then plan for multiple Servers and Databases.

Erik

Sandeep wrote in message <8abp48$2kq$1_at_nnrp1.deja.com>...
>Hi Erik,
>
>Thanks for your valuable input.
>We have already implemented (That's what we think!) your suggestions
>during our tuning exercise. That is the reason we could reduce earlier
>window of 12 Hrs. down to 6 Hrs.
>
>Only thing, which we could not do, was your suggestion no. 6. This was
>largely due to dependency in the present process.
>
>The average processor utilization during the 6 Hr. window is about 150%
>(out of 400%), although peak time utilization is about 350%.
>
>Let me just put forwards a few questions: -
>1. How much time do you think this process would take on a N4000/8, the
>present box being K460/4.
>2. How much time do you think it would take for me to run four such
>processes in parallel on a single N4000/8 box. Assuming that I take
>care of the resulting I/O bottlenecks.
>
>Though we are in a process of Modeling this, but I would really
>appreciate some sort of "scientific gut-feel" from your experience.
>
>Thanks and Regards
>Sandeep Khajuria
>
Received on Mon Mar 13 2000 - 00:00:00 CST