环境:
OS:Centos 7
DB:18.1.14
1.修改配置文件
vi sys.odbc.ini
PermSize=9192 ##这里的值根据情况设置
2.重新load
[instanceadmin@localhost ~]$ ttadmin -rampolicy manual sampledb ##设置为手工
[instanceadmin@localhost ~]$ ttadmin -ramunload sampledb
[instanceadmin@localhost ~]$ ttadmin -ramload sampledb
##重启ttDaemonAdmin不管用的
[instanceadmin@localhost conf]$ttDaemonAdmin -stop
[instanceadmin@localhost conf]$ttDaemonAdmin -start
3.查看设置是否生效
[instanceadmin@localhost ~]$ ttisql sampledb
Command> call ttconfiguration('permsize');
< PermSize, 9192 >
1 row found.
4.重新设置内存策略为always
[instanceadmin@localhost ~]$ ttadmin -rampolicy always sampledb
查看
[instanceadmin@localhost ~]$ ttadmin -query sampledb
RAM Residence Policy : always
Replication Agent Policy : manual
Replication Manually Started : False
Cache Agent Policy : manual
Cache Agent Manually Started : False
Database State : Open