1.log切换频率--log switch frequency map--diagnose
2.增加log日志组--redo logmanager--administor
3.为了减少ora-01555的产生，可以：
alter tablespace undotbs1 retention guarantee
4.
字符集al32utf8
密码复杂度
exclude db link
data ,index,lob 空间的新建
redo 512M*5
select 'Temp Tablespace use SYSTEM: ' from dual;
SELECT username, default_tablespace, temporary_tablespace
FROM dba_users
WHERE temporary_tablespace = 'SYSTEM';
select * from dba_users where account_status='OPEN' AND USER_NAME=
ALTER USER SCOTT LOCK;
SELECT * FROM DBA_SEGMENTS WHERE owner like 'COSTMANAGER'
NNC_DATA01
alter user NCHR_SYSTEM_MID default tablespace NNC_DATA01;
alter user NCHR_SYSTEM_MID_pow default tablespace NNC_DATA01;
alter user NCHR_user_mid default tablespace NNC_DATA01;
2.增加log日志组--redo logmanager--administor
3.为了减少ora-01555的产生，可以：
alter tablespace undotbs1 retention guarantee
4.
字符集al32utf8
密码复杂度
exclude db link
data ,index,lob 空间的新建
redo 512M*5
select 'Temp Tablespace use SYSTEM: ' from dual;
SELECT username, default_tablespace, temporary_tablespace
FROM dba_users
WHERE temporary_tablespace = 'SYSTEM';
select * from dba_users where account_status='OPEN' AND USER_NAME=
ALTER USER SCOTT LOCK;
SELECT * FROM DBA_SEGMENTS WHERE owner like 'COSTMANAGER'
NNC_DATA01
alter user NCHR_SYSTEM_MID default tablespace NNC_DATA01;
alter user NCHR_SYSTEM_MID_pow default tablespace NNC_DATA01;
alter user NCHR_user_mid default tablespace NNC_DATA01;
来自 “ ITPUB博客 ” ，链接：https://blog.itpub.net/21302630/viewspace-1728590/ ，如需转载，请注明出处，否则将追究法律责任。
上一篇：
weblogic集群搭建完成
请登录后发表评论
登录
全部评论
