日期:2014-05-16 浏览次数:20378 次
0、完全卸载
http://blog.csdn.net/pioayang/article/details/23847593
1、内存管理
http://blog.csdn.net/pioayang/article/details/23668279
2、数据重构
http://blog.csdn.net/pioayang/article/details/23678221
包括索引重构 alter index ... rebuild online的机制 http://blog.csdn.net/pioayang/article/details/23678497
3、group by 分组统计求和
http://blog.csdn.net/pioayang/article/details/23683899
4、constraint约束(主键、外键、条件)
http://blog.csdn.net/pioayang/article/details/23741185
5、索引
http://blog.csdn.net/pioayang/article/details/23754435
索引重构 alter index ... rebuild online的机制 http://blog.csdn.net/pioayang/article/details/23678497
深入解析B-Tree索引与Bitmap位图索引的锁代价 http://blog.csdn.net/pioayang/article/details/23935827
6、oracle 快速查询数据库各种信息、及转换对应java代码
http://blog.csdn.net/pioayang/article/details/11575257
7、表压缩
http://blog.csdn.net/pioayang/article/details/23758695
oracle表压缩技术(BAISC vs OLTP) http://blog.csdn.net/pioayang/article/details/23947717
8、OLTP&OLAP
(1) http://blog.csdn.net/pioayang/article/details/23759949
(2) http://blog.csdn.net/pioayang/article/details/23760169
9 物化视图
http://blog.csdn.net/pioayang/article/details/23762509
10 Oracle DDL,DML,DCL,TCL 基础概念
http://blog.csdn.net/pioayang/article/details/22665909
11 分区
http://blog.csdn.net/pioayang/article/details/23774715
在线重定义 http://blog.csdn.net/pioayang/article/details/23913359
错误处理:http://blog.csdn.net/pioayang/article/details/23914739
12 Cache
FAST Cache http://blog.csdn.net/pioayang/article/details/23827123
http://wenku.baidu.com/view/00000a063169a4517723a389.html
BUFFER CACHE http://blog.csdn.net/pioayang/article/details/23827299
13 临时表
http://blog.csdn.net/pioayang/article/details/23834537
14 rac
http://blog.csdn.net/pioayang/article/details/23847045
15 多个连接池
http://blog.csdn.net/pioayang/article/details/23848547
16 内存设置
sga pga http://blog.csdn.net/pioayang/article/details/23851531
http://blog.csdn.net/pioayang/article/details/23855143
17、Oracle 存储过程 动态sql执行
http://blog.csdn.net/pioayang/article/details/23853477
18、 Oracle 详解Oracle数据库优化方案与实践
http://blog.csdn.net/pioayang/article/details/23854515
19 表空间tablespace
查看修改 http://blog.csdn.net/pioayang/article/details/10924423
只读表空间 http://blog.csdn.net/pioayang/article/details/22670839
20 Scheduler / jobs
http://blo