create sequence emp_seq INCREMENT BY 1 -- 每次加几个 START WITH 1 -- 从1开始计数 NOMAXVALUE -- 不设置最大值 NOCYCLE -- 一直累加，不循环 CACHE 10 SELECT emp_seq.currval FROM DUAL select * from emp insert into emp values(emp_seq.nextval,'ss',sysdate,'24',3599,'14') 查看全文

手动切换TEMP 表空间. 查看全文

How can i recreate or relink conc manager(fndlibr ) with adadmin 查看全文

1. gather schema statistics regularly weekly once -full
2. gather schema statistics daily - atleast 10%
3. rebuild the fragmented indexes regularly - 15 days
4. coalesce the tablespaces monthly once
5. purge the unwanted data weekly once
6. pin the db objects into SGA with dbms_shared_pool package
7. find the objects which have become invalid and then validate them .
8. purge workflow runtime data
9. check the seeded alerts

oracle大表分区心得
最近在做一个客户关系管理系统，项目做的到不是非常成功，可还是学到了不少的知识，由于数据量很大，没有专门的oracle数据库人员支持，对数据库优化管理等也只有我这个约懂一点的人上了。在对数据库优化上有一点点心得写出来希望能同大家一起学习和交流。 查看全文