on 08-01-2016 4:57 AM
Hi Zulfadzly,
From the SYSTEMDB, execute the following command:
<= SPS10
ALTER SYSTEM ALTER CONFIGURATION ('indexserver.ini', 'DATABASE', '<tenant_DB>') SET ('memorymanager', 'allocationlimit') = '<allocate_MB>' WITH RECONFIGURE;
>= SPS11
ALTER SYSTEM ALTER CONFIGURATION ('global.ini', 'DATABASE', '<tenant_DB>') SET ('memorymanager', 'allocationlimit') = '<allocate_MB>' WITH RECONFIGURE;
Even through the configuration change takes effect immediately, a database restart is suggested as mis-handling of allocation memory could cause OOM and corrupt the data in memory which is mentioned in note 2175606 – HANA: How to set allocation limit for tenant databases
Regards,
Ning
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
84 | |
25 | |
12 | |
9 | |
6 | |
6 | |
5 | |
5 | |
4 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.