Solved

Memory Usage on Sun Solaris 2.7

Posted on 2002-05-30
4
237 Views
Last Modified: 2013-12-27
Hello,
  We are having a E450 with Solaris 2.7 Installed. We are running Oracle 8i 4 to 5 Instances. It is a development Server. Server RAM is 1.5 GB. and Swap Space is 2GB.
  The SGA Size of each Database instance is around 100M.
When Databases are started up and after some time all the memory is consumed. If a client takes a connection thru SQL it takes 100+ MB of RAM.
   Can any body give me solution.
Regards
Avadhani
0
Comment
Question by:avadhani
4 Comments
 
LVL 7

Accepted Solution

by:
waynezhu earned 50 total points
Comment Utility
There is a script to calculate the Oracle memory usage published in the recent Oracle Magazine (May issue, Page 26). Check it out to see if that helps.  

Also to reduce the memory usage, there are serveral
main places to check: for example, are you running JAVA applications? if NOT, you may reduce the java pool to a small size; SORT_AREA_SIZE is the main parameter to effect
the process memory usage and you may adjust to a small
value.

If you'd like to know more about Solaris memory,
take a look at this article and its associated links:
http://www.itworld.com/Comp/2402/UIR980301perf/
0
 
LVL 51

Expert Comment

by:ahoffmann
Comment Utility
you get a brief overview with:
  top
  vmstat
0
 
LVL 20

Expert Comment

by:tfewster
Comment Utility
No comment has been added lately, so it's time to clean up this Topic Area.
I will leave a recommendation for this question in the Cleanup topic area as follows:

- Answered by waynezhu

Please leave any comments here within the next 7 days

PLEASE DO NOT ACCEPT THIS COMMENT AS AN ANSWER !

tfewster
Cleanup Volunteer
0
 

Expert Comment

by:SpideyMod
Comment Utility
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Why You Should Analyze Threat Actor TTPs

After years of analyzing threat actor behavior, it’s become clear that at any given time there are specific tactics, techniques, and procedures (TTPs) that are particularly prevalent. By analyzing and understanding these TTPs, you can dramatically enhance your security program.

Join & Write a Comment

Introduction Regular patching is part of a system administrator's tasks. However, many patches require that the system be in single-user mode before they can be installed. A cluster patch in particular can take quite a while to apply if the machine…
FreeBSD on EC2 FreeBSD (https://www.freebsd.org) is a robust Unix-like operating system that has been around for many years. FreeBSD is available on Amazon EC2 through Amazon Machine Images (AMIs) provided by FreeBSD developer and security office…
Learn how to get help with Linux/Unix bash shell commands. Use help to read help documents for built in bash shell commands.: Use man to interface with the online reference manuals for shell commands.: Use man to search man pages for unknown command…
Learn how to navigate the file tree with the shell. Use pwd to print the current working directory: Use ls to list a directory's contents: Use cd to change to a new directory: Use wildcards instead of typing out long directory names: Use ../ to move…

762 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