topic Re: oracle 9i memory comsumption in Operating System - HP-UX

oracle 9i memory comsumption

Jeong Jin-wook — Mon, 07 Mar 2005 04:43:06 GMT

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?

Re: oracle 9i memory comsumption

G. Vrijhoeven — Mon, 07 Mar 2005 04:48:07 GMT

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

Re: oracle 9i memory comsumption

Mobeen_1 — Mon, 07 Mar 2005 04:51:48 GMT

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

Re: oracle 9i memory comsumption

Steve Steel — Mon, 07 Mar 2005 06:11:40 GMT

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