日期:2014-05-16  浏览次数:20378 次

Oracle 小结 目录

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