数据库安装部署后,默认的配置可能并不适合生产环境,需要进一步配置调整,以下整理一些常见配置脚本,方便大家使用,仅供参考。数据库版本DM8。欢迎大家补充!
select case_sensitive();
select para_name,para_value from v$dm_ini where para_name='LENGTH_IN_CHAR';
select para_name,para_value from v$dm_ini where para_name='COMPATIBLE_MODE';
sp_set_para_value(2,'COMPATIBLE_MODE',4);
systemctl stop DmServiceDMSERVER.service
systemctl start DmServiceDMSERVER.service
select distinct data_type from information_schema.columns
where table_schema in ('XXX','XXX');
alter database mount;
alter database add archivelog 'type=local,dest=/dm8/data/DAMENG/arch,file_size=512,space_limit=8192';
alter database archivelog;
alter database open;
alter system switch logfile;
select name,arch_mode from v$database;
select para_name,para_value from v$dm_ini where para_name like '%FLASHBACK%';
select para_name,para_value from v$dm_ini where para_name like '%UNDO_RETENTION%';
sp_set_para_value(1,'ENABLE_FLASHBACK',1);
sp_set_para_double_value(1,'UNDO_RETENTION',86400);
/dm8/bin/dexp userid=sysdba/xxxxxxx file=dexp_db_full_date +20%y-%m-%d
.dmp directory=/dm8/data/DAMENG/bak log=dexp_db_full_date +20%y-%m-%d
.log full=y
tar -zxvf /dm8/data/DAMENG/bak/dexp_db_full_date +20%y-%m-%d
.tar.gz /dm8/data/DAMENG/bak/dexp_db_full_date +20%y-%m-%d
.dmp --remove-files
find /dm8/data/DAMENG/bak/dexp_db_full* -type f -mtime +7 -exec rm {};
alter user sysdba limit password_life_time unlimited;
alter user sysdba limit password_lock_time unlimited;
select sf_get_para_value(2,'MAX_SESSIONS');
sp_set_para_value(2,'MAX_SESSIONS',1000);
select para_name,para_value,para_type,description from v$dm_ini where para_name like '%MEMORY%';
sp_set_para_value(2,'MEMORY_POOL',500);
sp_set_para_value(2,'MEMORY_TARGET',500);
select para_name,para_value,para_type,description from v$dm_ini where para_name like '%BUFFER%';
sp_set_para_value(2,'BUFFER',800);
sp_set_para_value(2,'MAX_BUFFER',800);
select para_name,para_value,para_type,description from v$dm_ini where para_name like '%RLOG_POOL_SIZE%';
sp_set_para_value(2,'RLOG_POOL_SIZE',256);
select para_name,para_value,para_type,description from v$dm_ini where para_name like '%CACHE_POOL_SIZE%';
sp_set_para_value(2,'CACHE_POOL_SIZE',256);
select para_name,para_value,para_type,description from v$dm_ini where para_name like '%DICT_BUF_SIZE%';
sp_set_para_value(2,'DICT_BUF_SIZE',50);
如果觉得我的文章对您有用,请点赞。您的支持将鼓励我继续创作!
赞2
添加新评论0 条评论