Oracle Specification

I have a client server program using DCOM. I have about 25 clients connected to a 800 MHZ server. The Oracle VErsion is 8i.  My server gets overloaded and the CPU usage comes to 100% during peak hours and the total network gets down.
The Server configuration.

I need the following clarifications

1. Initialization parameters.
2. About Redo & control file locations ( No's specify)
3. does Oracle 8i support Dual Processor ?
4. Is the version has to be upgraded for no of clients (Does Oracle defer with the no of clients)
5. Is there any settings to be made for Multiuser & multithreading ?

I need all clarifications for my above problems.

1. Pentium III - 800 Mhz
2. 356 MB RAM
3. 40 GB HDD
4. OS-Windows 2000 server Advanced.

The client machines are connected by switches.
Who is Participating?
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

I'll come back to point 1.

2. Doesn't seem to be an I/O problem, so this shouldn't matter. As a general rule try to mirror controlfile and redo groups across multiple disks for resilience.

3. Oracle 8i does support multi processor, but doesn't use it out of the box.

4. Version is fine for supporting thousands of clients.

5. Multithreaded server (MTS) wont give you any benefits until you have many hundreds of concurrent users.

If your performance is as bad as you say, then the main problem shouldn't be  too hard to spot. First off, check your OS and network - are you out of memory / paging? Is your network clogged.

Once you can narrow down the cause, someone can offer solutions.



Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
No comment has been added lately, so it's time to clean up this TA.
I will leave the following recommendation for this question in the Cleanup topic area:

Accept: BobMc {http:#8211721}

Please leave any comments here within the next four days.

EE Cleanup Volunteer
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.

Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.