How to use more Memory during DB defragmentation?
Hi, our Opscenter DB size is about 100GB. The Problem is, if we do a DB defragmentation it needs nearly 24 hours, in which the Opscenter is not available. I looked in the Opscenter Tuning guide and is says that you have to resize the -ch option in the server.cong. It should be half of the DB size, so it would be 50GB. I saw that during the DB defragmentation the job only uses like 100MB-200MB of RAM. There are 16GB of RAM available. In our test environment the DB is only 1GB big but during the defragmentation it uses nearly 1GB of RAM. There are 8GB of RAM available. Both are windows VM's. Did anyone of you had the same issue?