cancel
Showing results for 
Search instead for 
Did you mean: 

swapinfo information

SOLVED
Go to solution
mehul_3
Regular Advisor

swapinfo information

Hi all
Following result is shown after executing swapinfo
# swapinfo -atm
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 6144 277 5867 5% 0 - 1 /dev/vg00/lvol2
reserve - 5867 -5867
memory 2336 2209 127 95%
total 8480 8353 127 99% - 0 -

Could anybody tell what does reserve column indicate? and 99% utilization leads to a problem "Out of memeory" while application is running.
Note: if physical memory is 3GB then in above swapinfo what does memory column indicate?

Rgds,
Mehul
15 REPLIES
Joseph Loo
Honored Contributor

Re: swapinfo information

hi,

From "man swapinfo", the reserve column means the paging space on reserve which is needed by processes that r currently running, but that has not yet been allocated from one of the paging areas.

the memory seems quite low, do a vmstat to verify how bad swapping is occurring:

# vmstat 2 15
15 2-seconds interval

regards.
what you do not see does not mean you should not believe
Steve Steel
Honored Contributor

Re: swapinfo information

Hi


Best explanation I know is on

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



I would advise anybody to bookmark this site


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

Re: swapinfo information

What is dbc_max_pct set to? You may be able to free up some ram for your applications...

With 3GB of ram, dbc_max_pct of 20 or 25% should be fine.

Post a vmstat -S 2 10

-S Report the number of processes swapped in and out (si and so)

You may need to add more memory to the system - or add more swap space...

Rgds...Geoff
Proverbs 3:5,6 Trust in the Lord with all your heart and lean not on your own understanding; in all your ways acknowledge him, and he will make all your paths straight.
Thomas J. Harrold
Trusted Contributor

Re: swapinfo information

Mehul,

The "memory" row indicates that you have pseudo-swap or "lazy" swap mode enabled. (default on HP-UX). Up to 75% of physical memory can be dedicated to use as paging space. This is key on large memory systems. It's tough to set aside 2x physical memory (traditional recommendation) for paging space on a system with 128GB of RAM!

You can disable this with a kernel parameter change, but unless your app routinely chews up a ton of memory, I'd leave it set at the default.

-tjh
I learn something new everyday. (usually because I break something new everyday)
Ted Buis
Honored Contributor

Re: swapinfo information

Still if reducing buffer cache doesn't work, then you need more virtual address space on your system. You can buy more RAM, which is your best option, or you can create more device swap on a disk, or both. You are currently using 99% of your virtual address space of 8480MBbyes. Reducing buffer cache can't give you that much more space. Once you reach 100% on that bottom line of swapinfo -tam, you can no longer exec any new processes, so in won't be just poor performance, but processes not running or even dying.
Mom 6
mehul_3
Regular Advisor

Re: swapinfo information

Thanks for explanation.
We are still facing "Out of memory" problem from last 10 days.Either we have to abort the instance or kill user session which is not ideal solution.
Pl. suggest everlasting solution?

Waiting for immediate response.

Regards,
Mehul
Patrick Wallek
Honored Contributor

Re: swapinfo information

If you still see swap usage and vmstat shows a value consistently greater than 0 for the po column, then you choices are:

1) Reduce the memory usage on the system

2) Upgrade RAM

RAC_1
Honored Contributor

Re: swapinfo information

What is the OS version?? What is oracle version??
How many instances on this system??

what are the following kernel settings??
maxssiz
maxssiz_64bit
maxdsiz
maxdsiz_64bit
maxtsiz
maxtsiz_64bit
shmmax
There is no substitute to HARDWORK
Yogeeraj_1
Honored Contributor

Re: swapinfo information

hi Mehul,

Are you running an Oracle Database?

maybe you can also perform some tuning at this level also..

kind regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
mehul_3
Regular Advisor

Re: swapinfo information

OS version ::HP-UX11.11
Oracle version :: 9.2.0.1.0
How many instances on this system :: One Instance

Following are kernel settings
maxssiz 134217728
maxssiz_64bit 1073741824
maxdsiz 1073741824
maxdsiz_64bit 2147483648
maxtsiz 67108864
maxtsiz_64bit 1073741824
shmmax 2147483648

We have increased shmmax from 536870912 to 2147483648 to fit entire SGA and(Which is 1500MB,PGA 600MB) but problem still persists.

Note:Physical RAM is 3GB.
Concurrent user 25

Regards,
Mehul


RAC_1
Honored Contributor

Re: swapinfo information

You did not provide this.

What is oracle version??
How many instances on this system??
There is no substitute to HARDWORK
mehul_3
Regular Advisor

Re: swapinfo information

already provided pl.check it.

Regards,
Mehul
RAC_1
Honored Contributor
Solution

Re: swapinfo information

Get shminfo tool and check shared memory usage. I also inclined towards reducing the SGA. try it.
There is no substitute to HARDWORK
Yogeeraj_1
Honored Contributor

Re: swapinfo information

hi again,

can you post the output of "show sga"

login to the database as '/ as sysdba'

regards
yogeeraj
No person was ever honoured for what he received. Honour has been the reward for what he gave (clavin coolidge)
Rita C Workman
Honored Contributor

Re: swapinfo information

Set up some disk for swap and set it up so it will be there when you reboot too. That will keep you from totally choking out for the moment. I notice you only have lvol2.

[Memory total is the total of all available and would include the lvol2 disk]

3Gb is not alot of memory running anything Oracle over 8i. You need to look at increasing this, cause the newer versions of Oracle just keep putting more of a strain on memory, so you also need to look at all your kernel parms.
Post all your parms...and let folks look them over, there may be a few others that could be suggested for changes to help.

Just a thought,
Rgrds,
Rita