Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
?
Solved

How much RAM for oracle server?

Posted on 1999-01-29
2
Medium Priority
?
358 Views
Last Modified: 2008-03-06
Hi, how much RAM do i need for an oracle 8 server running on NT 4.0? for use with about 15 clients?
0
Comment
Question by:Jambyte
[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
2 Comments
 
LVL 35

Accepted Solution

by:
Mark Geerlings earned 200 total points
ID: 1083916
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
 

Expert Comment

by:vantive
ID: 1083917
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

Featured Post

Free Tool: ZipGrep

ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.

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

Question has a verified solution.

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

Checking the Alert Log in AWS RDS Oracle can be a pain through their user interface.  I made a script to download the Alert Log, look for errors, and email me the trace files.  In this article I'll describe what I did and share my script.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video explains at a high level with the mandatory Oracle Memory processes are as well as touching on some of the more common optional ones.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.

609 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