Solved

Memory Usage on Sun Solaris 2.7

Posted on 2002-05-30
4
243 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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

Suggested Solutions

Let's say you need to move the data of a file system from one partition to another. This generally involves dismounting the file system, backing it up to tapes, and restoring it to a new partition. You may also copy the file system from one place to…
I have been running these systems for a few years now and I am just very happy with them.   I just wanted to share the manual that I have created for upgrades and other things.  Oooh yes! FreeBSD makes me happy (as a server), no maintenance and I al…
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 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.:
Suggested Courses

752 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