Hello,
We are running MaxDB 7.6.06.03
on CentOS 5.3 with 16 GB RAM
MaxDB seems to be consuming the whole RAM ! the 16 GB
" MemTotal: 16440216 kB MemFree: 508564 kB Buffers: 288496 kB Cached: 3269404 kB SwapCached: 12764 kB Active: 12115428 kB Inactive: 2377076 kB HighTotal: 0 kB HighFree: 0 kB LowTotal: 16440216 kB LowFree: 508564 kB SwapTotal: 12289716 kB SwapFree: 12163328 kB Dirty: 4240 kB Writeback: 0 kB AnonPages: 10933132 kB Mapped: 121976 kB Slab: 1216804 kB PageTables: 164460 kB NFS_Unstable: 0 kB Bounce: 0 kB CommitLimit: 20509824 kB Committed_AS: 23502340 kB VmallocTotal: 34359738367 kB VmallocUsed: 275992 kB VmallocChunk: 34359462263 kB HugePages_Total: 0 HugePages_Free: 0 HugePages_Rsvd: 0 Hugepagesize: 2048 kB "
is this normal for Maxdb please ?
Configuration Parameters:
Cashe_size 1548032
Instance_tyoe OLTP
Log_Mirrored NO
Log_Segment_size 21333
Maxbackupdevs 2
MaxCPU 2
Maxdatavolumes 40040
Maxlogvolumes 2
Maxusertaks 500
MCOD NO
Data Area:
Volumes 2
totalsize 30.000,000 MB
Log Area
No. of log Volumes 1
Total Size 500,00 MB
ache Sizes Size
I/O Buffer Cache 12.094,00 MB
Data Cache 12.090,58 MB
Converter 2,39 MB
Misc. 1,03 MB
Catalog Cache 250,50 MB
Sequence Cache 0,01 MB
Cache Accesses
Accesses Successful Unsuccessful Hit Rate
Data Cache 1.257.150.612 1.256.627.690 522.922 99,96%
SQL Data 1.257.089.604 1.256.566.682 522.922 99,96%
OMS Data 0 0 0 100,00%
History/Undo 61.008 61.008 0 100,00%
Catalog Cache 26.144.043 25.192.771 952.028 96,36%
Sequence Cache 0 0 0 100,00%
Cache-Specific Parameter Settings
Value
CACHE_SIZE 12.094,00 MB
CAT_CACHE_SUPPLY 250,50 MB
Thanks alot for any help in advance