I guess so, maybe I should decrease the CacheSize to 10.000 Pages, right.. But then I can say, that the CacheSize runs full while using sapdb, so that sql-processes wouldn't be cleared, when there are finished, in the memory (cache) ?
regards, Danny
Am Mon, 28 Jul 2003 11:34:00 +0200 hat [EMAIL PROTECTED] <[EMAIL PROTECTED]> geschrieben:
Correct me if i am wrong, but are 800.000 pages *8kb = 6,4 GB cache, which will be used up on the first connect/use ?
cheers Kai
Zitat von Danny Tramnitzke <[EMAIL PROTECTED]>:
Hi all
I run a sapdb on a RedHat 8.0 System. This System has 1 GB Main Memory, and 2 Gb Swap Partition.
The SAPDB has 4 GB Data (2 GB full) and 1 GB Log (50 MB full) .
The ChacheSize of the sapdb amounts 800.000 Pages !
The Data Hit Chache Rate lies at 97 %.
Now the problem :
The sapdb writes the Main Memory till it's full. After that it writes the Swap Partition, also untill it's full. The problem is, that after a sapdb Process (e.g. select) is done, the memory is still full. So it wouldn't be cleared by sapdb after a selection. And so, after time and time, the memory and swap partition is full of sapdb data, and the system doesn't work anymore (overflow).
What might be the reason for that ? The high ChacheSize ?
Best regards, Danny
-- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
-- Using M2, Opera's revolutionary e-mail client: http://www.opera.com/m2/ _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
