Re: strange memory leak
- From: patrice <quet.patrice@xxxxxxx>
- Date: Fri, 05 Oct 2007 17:48:10 -0700
On 3 oct, 21:08, Dieter Stumpner <D.Stump...@xxxxxx> wrote:
p595pimp wrote:
we have been experiencing a strange memory problem with a new p550
server that is going to host a new JDE EnterpriseOne implementation.
So far, oracle & JDE are installed, and users are able to log in,
etc... everything seems to be fine EXCEPT...
the machine shipped with 8GB memory, as specified by the JDE/Oracle
requirements... all of the neccessary AIX & application prereq.
filesets & patches are installed (java, c-compiler, etc...)..
everything looks good except that the machine is hitting 80% memory
usage with only 12 users logged in!!! when we go live in a couple of
weeks, there will be aprox. 80 users.
I understand that we will probably need to add more memory (we're
thinking of going to 24GB), but still... the system should not be
hitting 80% of 8GB with only 12 users logged in. Also, we're
averaging 29% paging.
I don't know alot about oracle/jde, and there are a lot of processes
running from both... i'm suspecting the problem may be within the app
side... but the jde implementation guys are saying they don't know
whats wrong. so.
here is some output below... does anybody have any idea what might be
causing this, or have any suggestions?
Thanks!
-P
[SNIP] some vmm-stats
Hi!
Think you search on the wrong place for your problem! As far as i know
oracle (think u mean the db part) isnt a "normal" process. If you start
oracle *you* tell them how much memory it will use. Independent of
number of user oracle use! Dont know JDE, but it sounds like it uses a
java vm. Then the same problem: *you* define the amount of Memory the vm
can use.
First dont worry about 29% pagingspace used (read all the posts why) and
then use the oracle enterprise manager(?) to check your db buffers and
check out the jconsole to look if you give the java vm enough memory.
with best regards
Dieter Stumpner- Masquer le texte des messages précédents -
- Afficher le texte des messages précédents -
Hi,
When paging space fills up, it means that the system sends out
computational memory frames to paging space.
Computational pages are program pages. If the system has to send
frames to paging space to make room in memory, it takes time to put
them on the disks.
Worst, if he needs to repage in the computational pages because a
program like Oracle needs that page to continue its processing, the
system and application overall performance is suffering.
A very interesting vmo parameter called v_pinshm can be set to 1
(default value is 0).
This AIX parameter allows to pin shared memory segments into real
memory and avoids shared memory segments to be launched to paging
space.
In general, when it is not set on an oracle database server, Oracle
shared memory segments are sended out to paging space if room is
needed.
Regarding the memory counters you have (%computational < RAM), you
should not have a so big percentage of paging space used.
Try to launch svmon -Pgt 10 to see what processes are eating paging
space.
Either those processes are oracle processes with high shared memory
values or Java processes.
If you are running AIX 5.3, as it seems to be the case, try the
followings :
vmo -o lru_file_repage=0 (avoids to send computational pages to
paging space when numperm located between minperm and maxperm : this
is your case)
vmo -o lru_poll_interval=10
vmo -o v_pinshm=1 (allows shared memory segments to be pinned into
memory).
put lock_sga oracle parameter to true into instance init file
Check that the sum of memory of your oracle instances and JVMs are not
bigger than 80% of your RAM.
Stop/restart your databases and JVMs.
Everything should be OK after that.
Hope this helps and regards.
Patrice
/* I speak ONLY for myself. */
/* My views and my opinions do not in an way represent those of my
actual or previous employer, even if they like them and especially if
they don't... */
.
- References:
- Re: strange memory leak
- From: Dieter Stumpner
- Re: strange memory leak
- Prev by Date: Re: Lotus Notes Server Console
- Next by Date: Moving BFF files to CD
- Previous by thread: Re: strange memory leak
- Next by thread: Re: Need a time/date simulation utility
- Index(es):
Relevant Pages
|
