Link to home
Start Free TrialLog in
Avatar of tomeksw
tomeksw

asked on

What Hardware for oracle

What harwer (intel) is good for oracle database (100 users, 20 GB data)?
Avatar of kneea
kneea

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.
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
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. :-)
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
ASKER CERTIFIED SOLUTION
Avatar of ComTech
ComTech

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial