Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium


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

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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Question has a verified solution.

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

Exchange database can often fail to mount thereby halting the work of all users connected to it. Finding out why database isn’t mounting is crucial and getting the server back online. Stellar Phoenix Mailbox Exchange Recovery is a champion product t…
Blockchain technology enhances society similar to the Internet. Its effects are broad, disruptive, and will boost global productivity.
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 Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses

575 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