toad使用

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;

来自 “ ITPUB博客 ” ，链接：http://blog.itpub.net/21302630/viewspace-1728590/，如需转载，请注明出处，否则将追究法律责任。

转载于:http://blog.itpub.net/21302630/viewspace-1728590/