What Hardware for oracle

Posted on 2001-06-04
Medium Priority
Last Modified: 2010-05-18
What harwer (intel) is good for oracle database (100 users, 20 GB data)?
Question by:tomeksw

Expert Comment

ID: 6152041
It all depends on how much data the users are reading across the net.  With a database that large it might be the network which is more important than the server.

You need to know how many records the average user will access in a day or an hour.

You also need to know the size of the records that the user will access.

Then you can start calculating how much data will travel across the net, how much data will be read from the hard drive, etc.

The answer will vary from a single processor pc with ide hdd to a multiprocessor pc with raid array and a 1Gb fibre backbone, all depending on your numbers.
LVL 13

Expert Comment

ID: 6153130
kneea is correct; no one here can answer without more info on usage.  But the best route is not to ask here; your friendly Oracle rep will have access to benchmarking info that will suggest hardware for given sizes and throughputs of various example databases.  You can use compare their information with your expected needs and get just the right system a lot better than we here at EE could back-seat-driver guess your needs.

Oracle costs a fortune and part of the price is that they have people there to answer questions just like this whether you ask them or here on EE.  I'd advise you to ask them since they're the pros on their software and you're paying for their advice whether you get it or not.

LVL 11

Expert Comment

ID: 6155150
If you have no control over the rest of the network hardware and have just been told to make the server and make it work, it might be time to seek another job. :-)

Expert Comment

ID: 6283755
Hi all,

This question has been open for awhile. I am going to allow feedback from the questioner and experts. If it is not resolved, I will delete or accept an answer based on the info I have been given. Experts, feel free to offer input. I will monitor this question for a period of 5-7 days and come back and evaluate the situation.

If an Expert has helped, please accept with the answer button.

If returned to I will leave open for discussion.

Please do NOT accept this notice as answer.

Thank you,
Community Support Moderator

Accepted Solution

ComTech earned 0 total points
ID: 6310905
Question has been abandonded, author has not loged in since the question was asked.

No one has come back to this question, neither questioner nor Experts have reported since my 7 day notification. Therefore I shall examine the question once more and take action.

This question never contained an answer to the question asked. I will now refund the points and accept
my own answer, as there is merit to the contents. And move to PAQ

Thank you,
Community Support Moderator

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

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.

Join & Write a Comment

This article outlines why you need to choose a backup solution that protects your entire environment – including your VMware ESXi and Microsoft Hyper-V virtualization hosts – not just your virtual machines.
Sometimes when I'm using my iPad, one of my apps will start acting weird or it just stops working. After reading articles and finding solutions on my own, I decided to share solutions I have found helpful.
How to fix display issue, screen flickering issue when I plug in power cord to the machine. Before I start explaining the solution lets check out once the issue how it looks like after I connect the power cord. most of you also have faced this…
Through the video, you can check the migration process of Outlook PST file to PDF. Kernel for Outlook to PDF tool can convert Outlook emails with all attributes like Subject, To, From, Cc, Bcc and other folders such as Inbox, Outbox, Sent Items, Jun…

587 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