Simpler Navigation for Servers and Operating Systems - Please Update Your Bookmarks
Completed: a much simpler Servers and Operating Systems section of the Community. We combined many of the older boards, so you won't have to click through so many levels to get at the information you need. Check the consolidated boards here as many sub-forums are now single boards.
If you have bookmarked forums or discussion boards in Servers and Operating Systems, we suggest you check and update them as needed.
cancel
Showing results for 
Search instead for 
Did you mean: 

oracle 9i memory comsumption

Jeong Jin-wook
Contributor

oracle 9i memory comsumption

hpux:11.11
oracle:9i
cpu:4
memory:12G
server:SD

One of my customers had SD with 6G memory
They upgraded 6G memory to 12G memory.
After upgrading memory there was no change in memory utilization.
I found that oracle process except oracle background process consumes more memory than before.
Oracle process cumsumed 3-5Mb each before upgrading memory. But now it comsumes 7-12Mb each after upgrading memory.
What should I do? Is there any patch for that?
3 REPLIES
G. Vrijhoeven
Honored Contributor

Re: oracle 9i memory comsumption

Hi,

Oracle's memory consumption can be configured:

Check:
http://www.stanford.edu/dept/itss/docs/oracle/9i/server.920/a96533/memory.htm

HTH,

Gideon

Mobeen_1
Esteemed Contributor

Re: oracle 9i memory comsumption

Jeong,
It looks to me like you should consider to tune your Oracle 9i ? Have you tried this ?

http://www.stanford.edu/dept/itss/docs/oracle/9i/network.920/a96574/tuning.htm#1000511

In the above link, look at Memory tunining

regards
Mobeen
Steve Steel
Honored Contributor

Re: oracle 9i memory comsumption

Hi


ftp://eh:spear9@hprc.external.hp.com/memory.htm

see memory windows

and

http://www.oracle.com/technology/documentation/oracle9i.html

http://download-uk.oracle.com/docs/html/A97297_01/ch1_admin.htm#sthref168


Steve Steel
If you want truly to understand something, try to change it. (Kurt Lewin)