Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Mailing Lists -> Oracle-L -> High Memory Consumption on APP Server on Compiliing Application as SO (64 Bit) - HELP

High Memory Consumption on APP Server on Compiliing Application as SO (64 Bit) - HELP

From: VIVEK_SHARMA <VIVEK_SHARMA_at_infosys.com>
Date: Tue, 3 Feb 2004 11:23:59 +0530
Message-ID: <F0CB3C9983B77E4AB4ADEFA63DAB109F07114464@twrmsg03.ad.infosys.com>


Folks,

ROOT CAUSE - Memory Overflow (NO Free Primary memory left) during Operations=20
on APPLICATION Server m/c. This is seemingly causing CPUs to Choke too with High CPU Run Queue
(seen below).

When a NON-SO(Archival) Compiled Application executable completes execution=20
, the respective process ceases to exist. The Operating System
thereafter=20
Frees the Respective Shared , Resident & Personal Private memory Spaces of=20
the Exe.

When a SO(Shared Object) Compiled Application executable completes execution=20
, the respective process Continues to exist as this is the very
architecture=20
of SO Exes.

Seemingly the Operating System is NOT Freeing memory even though an Explicit Command(within the program code) has been given to Free the memory.

NOTE We are using the Pro*C Commands "malloc" & "free" to Allocate & free memory respectively in the Application.

Qs How can we FREE the memory ?=20
Qs How can we check where the memory is being consumed ? Qs Are there any Solaris UFS OR Veritas "mount" parameters /Other best practice parameters which=20

   would cause Freeing memory / LESSER memory management activities ? Qs Are there any Alternate Pro*C Code commands which would cause Freeing of memory?
Qs Any advice on how this issue can be approached ?

Will provide any Clarifications .

MISC. INFO. :- For the SAME Transaction Load i.e. ALL Other conditions remaining Same

vmstat [ When using Application Compiled with NON-SO mode ]

kthr memory page disk faults cpu
r b w swap free re mf pi po fr de sr s0 s6 s1 s6 in sy cs us sy id
1 0 0 68901544 34474168 1221 5478 303 2 2 0 0 15 0 15 0 10318 33407 9006 15 9 76
0 0 0 34612744 18855656 3426 13111 412 8 8 0 0 47 0 47 0 17211 98818 27025 46 25 29
2 0 0 34630872 18848792 2862 12427 150 0 0 0 0 104 0 102 0 19729 90400 31224 49 25 27
7 2 0 34663848 18847424 4759 12517 16 0 0 0 0 239 0 239 0 18192 79776 28921 58 22 20
0 0 0 34774736 18961984 3179 12735 24 16 16 0 0 110 0 107 0 16425 78600 25707 50 23 27
0 0 0 34803664 18950456 2465 8596 0 8 8 0 0 22 0 22 0 15843 63097 24430 52 22 26

INFERENCE Free Primary Memory =3D 18.9 GB , Free Swap Space =3D 34.8 GB, Idle=20
CPU =3D 26 % , CPU Run Queue =3D 0

vmstat [ When using Application Compiled with SO(Shared Objects) mode ]

kthr memory page disk faults cpu
r b w swap free re mf pi po fr de sr s0 s6 s1 s6 in sy cs us sy id
73 0 0 66150424 34502240 5266 11973 357 5 4 0 4 16 0 17 0 12996 93929 15053 41 18 41
196 1 0 15874584 2804560 3633 11756 2379 7 7 0 0 5 0 3 0 18917 63435 15354 74 26 0
189 0 0 15868576 2784424 3790 11742 2698 0 0 0 0 1 0 5 0 19087 74373 16871 73 27 0
196 0 0 15874440 2789632 3737 11411 2531 0 0 0 0 24 0 14 0 19095 85002 16518 74 26 0
197 0 0 15921560 2788272 2987 11081 3105 0 0 0 0 15 0 16 0 18472 64672 15074 77 23 0
177 0 0 15936000 2798272 3900 15477 2851 16 8 0 0 5 0 4 0 19588 70612 16189 72 28 0

INFERENCE Free Primary Memory =3D 2.79 GB , Free Swap Space =3D 15.9 GB, Idle=20
CPU =3D 0 % , CPU Run Queue =3D 177

Application Server Machine SF6800
CPUs =3D 24 @ 750 MHz
Total Primary RAM Memory 41 GB
Total Swap configured 59 GB
Total Number of concurrent Processes on APP server 5000=20 Solaris 9
Oracle 9.2.0.3.0
Application - Banking - Hybrid nature

Thanks



Please see the official ORACLE-L FAQ: http://www.orafaq.com

To unsubscribe send email to: oracle-l-request_at_freelists.org put 'unsubscribe' in the subject line.
--
Archives are at http://www.freelists.org/archives/oracle-l/
FAQ is at http://www.freelists.org/help/fom-serve/cache/1.html
-----------------------------------------------------------------
Received on Mon Feb 02 2004 - 23:53:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US