> i have made a sapdb 7.4.03 standard installation on Red Hat > 9.0 with 2GB > memory and 2 80GB hard disks and i run java swing clients > which connect by JDBC to the DB server. > after a time i observed that the memory expand till no more > is available (50 maxusertasks). furthermore each sapdb > threads (there are many) uses a lot (94MB) of memory. the > cachesize is 10000 pages.
Memory usage on Linux is quite different since Linux uses all the memory as filesystem cache. So don't be concerned about outputs of p. ex. "free" that show no more memory. The memory used by threads is shared so not each one of the threads has 94 MB but the whole database. 10.000 pages x 8 KB are about 80 MB and you need some shared areas for the libraries and for each connection. So 94 MB is exact the memory that's expected. If an application needs more memory the filesystem cache is automatically shrinked and the memory is free()'d again for the application. This is all by design. Greetz, SIEGENIA-AUBI KG Informationswesen i.A. Markus D�hr SAP-CC/BC, SAPDB-DBA Tel.: +49 6503 917-152 Fax: +49 6503 917-7152 E-Mail: [EMAIL PROTECTED] Internet: http://www.siegenia-aubi.com -- MaxDB Discussion Mailing List For list archives: http://lists.mysql.com/maxdb To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
