Solved

What Hardware for oracle

Posted on 2001-06-04
5
141 Views
Last Modified: 2010-05-18
What harwer (intel) is good for oracle database (100 users, 20 GB data)?
0
Comment
Question by:tomeksw
5 Comments
 
LVL 2

Expert Comment

by:kneea
Comment Utility
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.
0
 
LVL 13

Expert Comment

by:magarity
Comment Utility
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.

regards,
magarity
0
 
LVL 11

Expert Comment

by:RoadWarrior
Comment Utility
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. :-)
0
 

Expert Comment

by:ComTech
Comment Utility
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,
ComTech
Community Support Moderator
0
 

Accepted Solution

by:
ComTech earned 0 total points
Comment Utility
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,
ComTech
Community Support Moderator
0

Featured Post

Enabling OSINT in Activity Based Intelligence

Activity based intelligence (ABI) requires access to all available sources of data. Recorded Future allows analysts to observe structured data on the open, deep, and dark web.

Join & Write a Comment

Suggested Solutions

Title # Comments Views Activity
Phaser 4510 feed unit 11 54
Laptops screen 6 65
Refurbished 16 55
Macbook has frequent sleep / awake failures 25 66
This paper addresses the security of Sennheiser DECT Contact Center and Office (CC&O) headsets. It describes the DECT security chain comprised of “Pairing”, “Per Call Authentication” and “Encryption”, which are all part of the standard DECT protocol.
Internet Business Fax to Email Made Easy - With eFax Corporate (http://www.enterprise.efax.com), you'll receive a dedicated online fax number, which is used the same way as a typical analog fax number. You'll receive secure faxes in your email, fr…
Here's a very brief overview of the methods PRTG Network Monitor (https://www.paessler.com/prtg) offers for monitoring bandwidth, to help you decide which methods you´d like to investigate in more detail.  The methods are covered in more detail in o…

728 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

Need Help in Real-Time?

Connect with top rated Experts

9 Experts available now in Live!

Get 1:1 Help Now