Hello, we have a 9.1.3 BW-database running with 4 partitions on AIX 5.3 64-bit. We have set the bufferpools for partion 0 to 1.6GB and for the others each to 1.2GB. The server has 36GB RAM but nmon or topas shows that this is already complete allocated and additional 10GB Swaps are allocated.
Is there a way to calculate all memory the database is allocating? Maybe we missed something. We want to reduce the memory consumption of the db, to get the db out of the swap space.