Hi Danny, Danny Tramnitzke wrote: > > Sorry for spam again, but I found the definition-text of the ChacheSize : > > ---- > 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)
The "(4 bytes integer)" only defines the storage size of the parameter- Thus you can set values up to 2^32/2 in it. The Link http://www.sapdb.org/7.4/htmhelp/90/9e0d0c954e11d5993300508b6b8b11/content.htm points out: The general database parameter CACHE_SIZE denotes the size of the I/O buffer cache in pages. Therefore, as a page is 8kByte, you can calculate the right size of the consumed memory. Sure, this memory should be smaler than the main memory decreased by all the other needs in the system to prevent paging here. BTW, for R/3 systems the hitrate of the Cache should be near to 99% or even 100% after some time of full operation. But give it some time to get its balance here. Ciao Ralf _______________________________________________ sapdb.general mailing list [EMAIL PROTECTED] http://listserv.sap.com/mailman/listinfo/sapdb.general
