Hi,
most of the memory ressources is in the data cache which is configured by
the db paramter DATA_CACHE (in 8kb pages). Sapdb does not use the data cache
on start but will take it when needed. Also, don't forget the database
kernel processes work in shared memory (same memory for all process) with
only a few kb for private data. On Linux, if you type the "free" command you
will see that the database takes only 50 Mb and not n x 50 Mb.
Yves
-----Original Message-----
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Andreas W. Ditze
Sent: 3 décembre, 2001 14:42
To: [EMAIL PROTECTED]
Subject: How to limit database memory ressources?
Hi,
can anyone tell me how to limit memory ressources occupied by sap-db? It
would also help to limit the number of processes spawn at sap-db start.
Everytime I run "top", my server says something like this....
[...]
428 sapdb 9 0 51380 50M 3692 S 0.0 10.0 0:00 db:TSTDB
429 sapdb 9 0 51380 50M 3692 S 0.0 10.0 0:00 db:TSTDB
430 sapdb 9 0 51380 50M 3692 S 0.0 10.0 0:00 db:TSTDB
431 sapdb 9 0 51380 50M 3692 S 0.0 10.0 0:00 db:TSTDB
432 sapdb 9 0 51380 50M 3692 S 0.0 10.0 0:00 db:TSTDB
433 sapdb 9 0 51380 50M 3692 S 0.0 10.0 0:00 db:TSTDB
434 sapdb 9 0 51380 50M 3692 S 0.0 10.0 0:00 db:TSTDB
435 sapdb 9 0 51380 50M 3692 S 0.0 10.0 0:00 db:TSTDB
436 sapdb 9 0 51380 50M 3692 S 0.0 10.0 0:00 db:TSTDB
437 sapdb 9 0 51380 50M 3692 S 0.0 10.0 0:00 db:TSTDB
[...]
Unfortunatly this is not the complete list of unused db-tasks ;-)
What has to be done?
Greetings
Andreas
