Oracle 9i Release 9.2.0.2 and swap memory

[Andres Valentin Lopez]

Hi

I have installed Oracle 9i Release 9.2.0.2 in a HP rx1620 Itanium Server with 2GB in RAM and HP-UX 11.23 Sep04 Patch Bundle , 4GB in swap and two Oracle instances, unexpectedly the use of memory is 100% or 90% or 80% and swap memory utilization is 13% or 15%.

swapinfo -at
Kb Kb Kb PCT START/ Kb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 4194304 560016 3634288 13% 0 - 1 /dev/vg00/lvol2
reserve - 3146352 -3146352
memory 2085668 1807124 278544 87%
total 6279972 5513492 766480 88% - 0 -

And the result of this behavior are desconnections of my oracle sessions (about 150 sessions)

Any idea?

Thx for your help

[A. Clay Stephenson]

Generally speaking, you are running a timy amount of memory for even one instance of Oracle these days. Look at your dbs_max_pct kernel tunable; if it is at the default value of 50% reduce it to no more than about 10% and set dbc_min_pct to about 5%.

You also probably need to reduce the size of your SGA's because any gains that you might get from database i/o caching is being overwhelmed byu a factor of 100 or more by your swapping.

The real fix for you is more physical memory.

[Julio Yamawaki]

Hi,

First of all, what is the size of this instances' SGA?
You must add this two sizes and see how much free memory you will have for user processes.
Are you using dedicated or shared server?
Dedicated server use much more memory than shared server. Also, if you have dedicated server and high parameters in SORT and HASH areas, you may have a memory shortage even with a small number of users.
Speaking about users, I have a unix box with about 150 users using Oracle 9i and Delphi and it demands about 3 GB of memory, with a 600 GB size DB.

Regards,

[Yogeeraj_1]

hi Andres,

are there any errors reported when the Oracle sessions are disconnected?

User errors?
Errors in init.ora?

revert

kind regards
yogeeraj