Solved

What Hardware for oracle

Posted on 2001-06-04
5
145 Views
Last Modified: 2010-05-18
What harwer (intel) is good for oracle database (100 users, 20 GB data)?
0
Comment
Question by:tomeksw
[X]
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
5 Comments
 
LVL 2

Expert Comment

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

Expert Comment

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

regards,
magarity
0
 
LVL 11

Expert Comment

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

Expert Comment

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

Accepted Solution

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

Featured Post

Creating Instructional Tutorials  

For Any Use & On Any Platform

Contextual Guidance at the moment of need helps your employees/users adopt software o& achieve even the most complex tasks instantly. Boost knowledge retention, software adoption & employee engagement with easy solution.

Question has a verified solution.

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

this article is a guided solution for most of the common server issues in server hardware tasks we are facing in our routine job works. the topics in the following article covered are, 1) dell hardware raidlevel (Perc) 2) adding HDD 3) how t…
Stuck in voice control mode on your Amazon Firestick?  Here is how to turn it off!!!
Come and listen to Percona CEO Peter Zaitsev discuss what’s new in Percona open source software, including Percona Server for MySQL (https://www.percona.com/software/mysql-database/percona-server) and MongoDB (https://www.percona.com/software/mongo-…
Monitoring a network: why having a policy is the best policy? Michael Kulchisky, MCSE, MCSA, MCP, VTSP, VSP, CCSP outlines the enormous benefits of having a policy-based approach when monitoring medium and large networks. Software utilized in this v…

705 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