Oracle Specification

Posted on 2003-03-26
Medium Priority
Last Modified: 2012-06-21

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.
Question by:Easysoft
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions

Accepted Solution

BobMc earned 200 total points
ID: 8211721
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.


LVL 17

Expert Comment

ID: 10360585
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

Featured Post

Get proactive database performance tuning online

At Percona’s web store you can order full Percona Database Performance Audit in minutes. Find out the health of your database, and how to improve it. Pay online with a credit card. Improve your database performance now!

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

A company’s centralized system that manages user data, security, and distributed resources is often a focus of criminal attention. Active Directory (AD) is no exception. In truth, it’s even more likely to be targeted due to the number of companies …
This post contains step-by-step instructions for setting up alerting in Percona Monitoring and Management (PMM) using Grafana.
Polish reports in Access so they look terrific. Take yourself to another level. Equations, Back Color, Alternate Back Color. Write easy VBA Code. Tighten space to use less pages. Launch report from a menu, considering criteria only when it is filled…
In this video, Percona Solution Engineer Rick Golba discuss how (and why) you implement high availability in a database environment. To discuss how Percona Consulting can help with your design and architecture needs for your database and infrastr…

777 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question