Solved

Memory Usage on Sun Solaris 2.7

Posted on 2002-05-30
4
244 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
[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
4 Comments
 
LVL 7

Accepted Solution

by:
waynezhu earned 50 total points
ID: 7051231
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
ID: 7054130
you get a brief overview with:
  top
  vmstat
0
 
LVL 21

Expert Comment

by:tfewster
ID: 8052919
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
ID: 8099646
per recommendation

SpideyMod
Community Support Moderator @Experts Exchange
0

Featured Post

Get 15 Days FREE Full-Featured Trial

Benefit from a mission critical IT monitoring with Monitis Premium or get it FREE for your entry level monitoring needs.
-Over 200,000 users
-More than 300,000 websites monitored
-Used in 197 countries
-Recommended by 98% of users

Question has a verified solution.

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

In tuning file systems on the Solaris Operating System, changing some parameters of a file system usually destroys the data on it. For instance, changing the cache segment block size in the volume of a T3 requires that you delete the existing volu…
Java performance on Solaris - Managing CPUs There are various resource controls in operating system which directly/indirectly influence the performance of application. one of the most important resource controls is "CPU".   In a multithreaded…
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
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…
Suggested Courses

630 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