exec(2): insufficient swap or memory available.

[Sajjad Sahir]

Dear Almond
I think u can close this thread and u can assign points. Once u got answers please close thread and give points to the peoples then only next time onwards peoples will answer u all threads asap

Thanks once more

sajjad

[Don Morris_1]

From the outputs you've posted, not only are you exhausting swap space -- you're presumably paging pretty well as well (you show that you're actually *using* 1.6Gb of swap device space and you're close to memory exhaustion).

Adding more swap may allow for running more processes, but your performance is going to be decidedly sub-optimal (some would say abominable) since your non-locked memory pages [Oracle usually locks the SGA in memory, but that's all] will be pushed to swap and back (thrashing).

Reduce your workload or add more memory (unless of course you don't mind waiting for disk I/Os all the time... your call, I suppose).

[apple]

ohh sorry for the late assigning of points. was concentrating on documentation last couple of days.
appreciate you can confirm my understanding. as shown below, our physical memory is 16GB, 8192 is configured as swap space, i need to configure swap space as double of our physical memory. i need to configure another 8160 of swap memory based on my calculation ->16*2-8192=8160MB). moving forward i can provision on disc of about 8 GB and configure it as swap memory? am i right? promise of good points. thanks a lot
Mb Mb Mb PCT START/ Mb
TYPE AVAIL USED FREE USED LIMIT RESERVE PRI NAME
dev 8192 677 7515 8% 0 - 1 /dev/vg00/lvol2
reserve - 7515 -7515
memory 8015 5762 2253 72%
total 16207 13954 2253 86% - 0 -

[Yogeeraj_1]

hi,

Yes. You can create an additional pseudo swap. It is much easier using SAM.

if you need any further assistance, do let us know.


kind regards
yogeeraj

[Dennis Handly]

>Our physical memory is 16GB, 8192 is configured as swap space,

I only see about 8 Gb of memory (from the memory line) and 8 Gb of swap device.

[Don Morris_1]

Yeah, something's odd there if your physical is supposed to be 16Gb. Usually pseudo-swap is between 75% to 7/8ths of real physical available after the early boot kernel consumption. That implies that either you really have closer to 9 or 10Gb... or your kernel is eating half your box in early boot.

If the latter -- what release and tunable settings is appropriate.

Can you compile and run the attached and post the output? I'd like to see just what the kernel thinks is there physically. If it is supposed to be 16Gb and the kernel only got 9Gb you may simply have some bad DIMMs [or a misconfigured vPar?] at the heart of this issue. If there's 16Gb in the kernel but only 8Gb in pseudo-swap, we need to find why the kernel used so much at boot.

[apple]

meaning i have 8 GB of physical memory. im sorry i don't know how to read the output from swapinfo -tam.
memory 8015 5762 2253 72%
ok, current used is 5 GB and free is 2 GB.

<> this statement is very interesting, meaning i need to add physical memory is it? if i add swap space of addiotional 8 GB? will it be very helpful to improve our database performance?

2. if with this swapinfo -tam output, and we have one new request to accomodate one new database requirement of 8GB of memory for their processing, what would be the best approach? do u think we can tune somewhere the memory rather than invest on buying additinal 8 GB of memory? if we need to buy, how big memory we need to buy?

3. to confirm steps to create additonal of 8GB of swap space is: provision 8GB of SAN storage to the server and configure it as per your steps as swap space? appreciate you can highlight if my understanding is wrong.
would really appreciate your advice. hope to hear from you. thanks a lot

[Yogeeraj_1]

Hi,

dont forget to post the output requested by Don above. This will shed some more lights on your current memory/swap configuration.

Once you have copied the script to your system, you can compile it using the following commands:

cc +DD32 -D_PSTAT64 mem_details.c -o mem_details

to run the program, try:
./mem_details

revert!

kind regards
yogeeraj

[Yogeeraj_1]

> this statement is very interesting, meaning i need to add physical memory is it? if i add swap space of addiotional 8 GB? will it be very helpful to improve our database performance?

Addtion of extra physical memory does not implicit mean improvement of database performance. If you are running in DEDICATED SERVER mode and that you have lots of connection to the database server, then there will definitely be a gain in performance. Tunning of the database itself, will something different and a few more aspects will have to be looked into.

NB. You will need to collect some statistics on the current database performance prior to any further changes so that you can gauge any improvements. I would start with running oracle STATSPACK reports...

kind regards
yogeeraj

[apple]

NB. You will need to collect some statistics on the current database performance prior to any further changes so that you can gauge any improvements. I would start with running oracle STATSPACK reports...>> meaning our database admin need to perform this? what can be done to gauge or measure the improvement from system administration point of view?

[Jeeshan]

Both system administrator and DBA part need to analyze to get some reports.

The DBA part, they can handle to generate their reports. and from the system part, you can collect the resource usage report and analyze the trendz and can figure out the future upgrade or else.

[YAQUB_1]

Hi,

Can U put below output here:-

# uname -a
# model
# bdf
# dmesg
# swapinfo -a
# vgdisplay -v /dev/vg00
# kctune or kmtune

[Dennis Handly]

>meaning i need to add physical memory is it? if i add swap space of additional 8 GB? will it be very helpful to improve our database performance?

If you add memory it may help. If you only add device swap and you add another database, it will be even slower.

>2. if with this swapinfo -tam output, and we have one new request to accommodate one new database requirement of 8GB of memory for their processing, what would be the best approach? do you think we can tune somewhere the memory rather than invest on buying additional 8 GB of memory?

Do you have the expertise to tune it?

>if we need to buy, how big memory we need to buy?

More is better. :-)

[Yogeeraj_1]

> meaning our database admin need to perform this?
Yes. The DBA should know how to do this. if you need any kind of assistance on this, do let us know.

kind regards
yogeeraj

[Yogeeraj_1]

hi again,

>what can be done to gauge or measure the improvement from system administration point of view?

At the OS level, you can run collect your overall performance using the HP Measureware. Basically, you will have to run the "extract" utility to dump data for a particular period and generate appropriate performance graphs.

e.g. (Extract performance data for the day and emails to me every night)
59 23 * * * /opt/perf/bin/extract -xp -r /home/yogi/zgbltemplate -g -b today 00:0
0 -e today 23:59 -f stdout | /bin/mailx -s "SRV2: Measureware Performance figures - FULL DAY " myemailaddress@mydom.mu >/dev/null 2>&1

hope this helps too!
kind regards
yogeeraj