---- The value specifies the i/o capable memory used by the data cache and the converter. It is very important for the performance of the database.
The converter transforms a logical page number into a physical block address on the data volumes. Caused by the importance the converter resides completely in the memory. The remaining memory is used by the data cache.
Use the database monitoring to obtain information about the data cache hit rate and the performance of the system.
The lower and upper limits are:
800 <= CACHE_SIZE <= 2147483640(4 bytes integer) ----
What means 4 byte integer ? What might be the right CacheSize for round 80 MB ?
10.000 (80MB/8KB) or something bigger ( x GB / 4B ) ??
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
