• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 366
  • Last Modified:

How much RAM for oracle server?

Hi, how much RAM do i need for an oracle 8 server running on NT 4.0? for use with about 15 clients?
0
Jambyte
Asked:
Jambyte
1 Solution
 
Mark GeerlingsDatabase AdministratorCommented:
I've used it with 128MB and 256MB, but had much better response times on a server with 512MB.  That was on a system with 20-30 concurrent users.  Limit your Oracle SGA to about 50% of the total RAM (this assumes your server is dedicated to Oracle with nothing else running on it, if there are other applications, printers, etc. you will need a smaller Oracle SGA).  The size of your database is also a factor.  With 512MB you can have an Oracle SGA of about 250MB and database block buffers of about 200MB.  That usually gave sub-second response times in our 1-gig database with a few million-row tables.
Another important consideration is the number of hard drives - the more the better.  Fewer than six will likely mean you are limited much more by disk I/O than memory.  Avoid RAID if possible.
0
 
vantiveCommented:
Depends on your way to connect as well. Oracle 8 is object-oriented so requires a huge quantity of memory. I think it would work fine if you use at least 512M.

0
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

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.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now