收缩表段(shrink space)

﹏ヽ暗。殇╰゛Y 2022-05-15 07:26 226阅读 0赞

\--====================  
\-- 收缩表段(shrink space)  
\--====================  
  
**一、表的增长方式**  
当表被创建后，随着记录的不断插入，组成表的区间会被填满，如果启用了自动扩展，则当区间填满后，会分配新的区间。假定高水  
位线随着记录的增加从最左端往右端来移动，当到底部区间的尾端时，则新的区间将会被分配。  
  
**二、表可收缩的原理**  
随着记录的增加高水位线不断的右移，记录的删除不会导致高水位线往回(左)移动  
删除记录后的空闲空间(高水位线左侧)尽管可以使用，但其稀疏性导致空间空闲  
注：完整的表扫描所耗费的时间不会因为记录的减少(删除)而减少  
  
**三、使用 alter table tbname shrink space 来收缩表段**  
1. 实现原理  
实质上构造一个新表(在内部表现为一系列的DML操作,即将副本插入新位置，删除原来位置的记录)  
靠近末尾处(右端)数据块中的记录往开始处(左端)的空闲空间处移动(DML操作)，不会引起DML触发器  
当所有可能的移动被完成，高水位线将会往左端移动(DDL操作)  
新的高水位线右边的空闲空间被释放(DDL操作)  
  
2. 实现前提条件  
必须启用行记录转移(enable row movement)  
仅仅适用于堆表,且位于自动段空间管理的表空间(堆表包括:标准表,分区表,物化视图容器,物化视图日志表)  
  
3. 不能实现收缩的表  
群集表  
具有LONG类型列的表  
LOB段(尽管表本身可以被缩小)，注，10gR2以后版本支持对LOB段的收缩  
具有基于提交的物化视图的表(因为禁用了触发器)  
具有rowid物化视图的表(因为rowid发生了变化)  
IOT映射表IOT溢出段  
索引基于函数的表  
未启用行记录转移的堆表  
  
4. 段收缩的优点  
提高缓存利用率，提高OLTP的性能  
减少磁盘I/O，提高访问速度，节省磁盘空间  
段收缩是在线的，索引在段收缩期间维护，不要求额外的磁盘空间  
  
5. 两个选项  
cascade:缩小表及其索引，并移动高水位线，释放空间  
compact:仅仅是缩小表和索引，并不移动高水位线，不释放空间  
alter table tbname shrink space 相当于带cascade参数  
  
**四、实战演习**  
  
1. 查看需要收缩的表段的基本情况，此处为表big\_table

> SQL> col SEGMENT\_NAME format a20 SQL> select OWNER,SEGMENT\_NAME,BYTES/1024/1024,BLOCKS from dba\_segments 2 where owner='SCOTT' and SEGMENT\_NAME='BIG\_TABLE'; OWNER SEGMENT\_NAME BYTES/1024/1024 BLOCKS ------------------------------ -------------------- --------------- ---------- SCOTT BIG\_TABLE 120 15360 SQL> select table\_name,blocks,empty\_blocks from dba\_tables 2 where table\_name='big\_table' and owner='scott'; -->未更新统计信息前BLOCKS，EMPTY\_BLOCKS列为空 TABLE\_NAME BLOCKS EMPTY\_BLOCKS ------------------------------ ---------- ------------ BIG\_TABLE SQL> exec dbms\_stats.gather\_table\_stats(ownname=>'SCOTT',tabname=>'BIG\_TABLE',estimate\_percent=>30); PL/SQL procedure successfully completed. SQL> select TABLE\_NAME,BLOCKS,EMPTY\_BLOCKS from dba\_tables 2 where TABLE\_NAME='BIG\_TABLE' and owner='SCOTT'; TABLE\_NAME BLOCKS EMPTY\_BLOCKS ------------------------------ ---------- ------------ BIG\_TABLE 14590 0 -->使用gather\_table\_stats时不会统计EMPTY\_BLOCKS块 SQL> analyze table big\_table compute statistics; -->使用analyze更新统计信息后EMPTY\_BLOCKS得到数据 Table analyzed. SQL> select TABLE\_NAME,BLOCKS,EMPTY\_BLOCKS from dba\_tables 2 where TABLE\_NAME='BIG\_TABLE' and owner='SCOTT'; TABLE\_NAME BLOCKS EMPTY\_BLOCKS ------------------------------ ---------- ------------ BIG\_TABLE 14590 770 SQL> set serveroutput on; SQL> exec show\_space('BIG\_TABLE','SCOTT'); -->使用show\_space过程或的BIG\_TABLE上的空间分配信息 Unformatted Blocks ..................... 0 FS1 Blocks (0-25) ...................... 0 -->空闲度为0-25%的块数。FS1,FS2,FS3,FS4为空闲度所占的百分比 FS2 Blocks (25-50) ..................... 0 FS3 Blocks (50-75) ..................... 0 FS4 Blocks (75-100)..................... 0 Full Blocks ............................ 14,427 Total Blocks............................ 15,360 Total Bytes............................. 125,829,120 Total MBytes............................ 120 Unused Blocks........................... 770 Unused Bytes............................ 6,307,840 Last Used Ext FileId.................... 4 Last Used Ext BlockId................... 16,521 Last Used Block......................... 254 PL/SQL procedure successfully completed.

2. 删除记录之后，进行收缩表段

> SQL> delete from big\_table where owner in ('SCOTT','SYSTEM'); -->删除记录 8715 rows deleted. SQL> commit; Commit complete. SQL> alter table big\_table shrink space; -->实施shrink,提示没有启用ROW MOVEMENT alter table big\_table shrink space \* ERROR at line 1: ORA-10636: ROW MOVEMENT is not enabled SQL> alter table big\_table enable row movement; -->开启row movement Table altered. SQL> alter table big\_table shrink space; -->shrink成功 Table altered. SQL> exec show\_space('BIG\_TABLE','SCOTT'); -->从下面的结果中可以看到块数以及总大小已经变小 Unformatted Blocks ..................... 0 FS1 Blocks (0-25) ...................... 1 FS2 Blocks (25-50) ..................... 1 FS3 Blocks (50-75) ..................... 0 FS4 Blocks (75-100)..................... 0 Full Blocks ............................ 14,318 Total Blocks............................ 14,488 Total Bytes............................. 118,685,696 Total MBytes............................ 113 Unused Blocks........................... 5 Unused Bytes............................ 40,960 Last Used Ext FileId.................... 4 Last Used Ext BlockId................... 16,521 Last Used Block......................... 147 PL/SQL procedure successfully completed.

3. 验证cascade与compact的差异

> SQL> delete from big\_table where rownum<8000; -->再次删除一些记录 7999 rows deleted. SQL> alter table big\_table shrink space compact; -->使用compact方式收缩表段 Table altered. SQL> exec show\_space('BIG\_TABLE','SCOTT'); Unformatted Blocks ..................... 0 FS1 Blocks (0-25) ...................... 1 FS2 Blocks (25-50) ..................... 2 FS3 Blocks (50-75) ..................... 0 FS4 Blocks (75-100)..................... 103 Full Blocks ............................ 14,214 --仅有的变化为14318-14214=104块，即完全填满的数据块减少了104块 Total Blocks............................ 14,488 --数据的总块数及总大小并没有减少，即未移动高水位线 Total Bytes............................. 118,685,696 Total MBytes............................ 113 Unused Blocks........................... 5 Unused Bytes............................ 40,960 Last Used Ext FileId.................... 4 Last Used Ext BlockId................... 16,521 Last Used Block......................... 147 PL/SQL procedure successfully completed. SQL> alter table big\_table shrink space cascade; -->使用cascade方式收缩， Table altered. SQL> exec show\_space('BIG\_TABLE','SCOTT'); Unformatted Blocks ..................... 0 FS1 Blocks (0-25) ...................... 1 FS2 Blocks (25-50) ..................... 2 FS3 Blocks (50-75) ..................... 0 FS4 Blocks (75-100)..................... 0 Full Blocks ............................ 14,214 Total Blocks............................ 14,384 -->总块数及总大小均已减少 Total Bytes............................. 117,833,728 Total MBytes............................ 112 Unused Blocks........................... 4 Unused Bytes............................ 32,768 Last Used Ext FileId.................... 4 Last Used Ext BlockId................... 16,521 Last Used Block......................... 44 PL/SQL procedure successfully completed. -->收缩之后索引依然有效 SQL> select OWNER,INDEX\_NAME,STATUS from dba\_indexes where TABLE\_NAME='BIG\_TABLE'; OWNER INDEX\_NAME STATUS ------------------------------ ------------------------------ -------- SCOTT BIG\_TABLE\_PK VALID

**五、语法总结：**

> ALTER TABLE <table\_name> ENABLE ROW MOVEMENT -->前提条件 ALTER TABLE <table\_name> SHRINK SPACE \[ <NULL> | COMPACT | CASCADE \]; ALTER TABLE <table\_name> SHRINK SPACE COMPCAT; -->缩小表和索引，不移动高水位线，不释放空间 ALTER TABLE <table\_name> SHRINK SPACE; -->收缩表，降低高水位线; ALTER TABLE <table\_name> SHRINK SPACE CASCADE; -->收缩表，降低高水位线，并且相关索引也要收缩一下 ALTER TABLE <table\_name> MODIFY LOB (lob\_column) (SHRINK SPACE); -->收缩LOB段 ALTER INDEX IDXNAME SHRINK SPACE; -->索引段的收缩，同表段

**六、批量收缩脚本**  
1. 普通表(根据相应需求修改下面的语句生产相应脚本)

> select'alter table '||table\_name||' enable row movement;' ||chr(10)||'alter table '||table\_name||' shrink space;'||chr(10)from user\_tables; select'alter index '||index\_name||' shrink space;'||chr(10)from user\_indexes;

2. 分区表的处理  
  
分区表进行shrink space时发生ORA-10631错误.shrink space有一些限制.  
  
在表上建有函数索引（包括全文索引）会失败。

> \--根据相应需求修改下面的语句生产相应脚本 select 'alter table '||owner||'.'||table\_name||' enable row movement;' ||chr(10)||'alter table '||owner||'.'||table\_name||' shrink space;'||chr(10) from dba\_tables where owner=upper('&input\_owner'); select 'alter index '||owner||'.'||index\_name||' shrink space;' ||chr(10) from dba\_indexes where uniqueness='NONUNIQUE' ; select 'alter table '||owner||'.'||segment\_name||' modify partition '||partition\_name||' shrink space;' ||chr(10) from dba\_segments where segment\_type='TABLE PARTITION';

3. 附show\_space脚本(来自Tom大师)

> CREATE OR REPLACE PROCEDURE show\_space ( p\_segname IN VARCHAR2, p\_owner IN VARCHAR2 DEFAULT USER, p\_type IN VARCHAR2 DEFAULT 'TABLE', p\_partition IN VARCHAR2 DEFAULT NULL ) -- this procedure uses authid current user so it can query DBA\_\* -- views using privileges from a ROLE, and so it can be installed -- once per database, instead of once per user who wanted to use it AUTHID CURRENT\_USER AS l\_free\_blks NUMBER; l\_total\_blocks NUMBER; l\_total\_bytes NUMBER; l\_unused\_blocks NUMBER; l\_unused\_bytes NUMBER; l\_LastUsedExtFileId NUMBER; l\_LastUsedExtBlockId NUMBER; l\_LAST\_USED\_BLOCK NUMBER; l\_segment\_space\_mgmt VARCHAR2(255); l\_unformatted\_blocks NUMBER; l\_unformatted\_bytes NUMBER; l\_fs1\_blocks NUMBER; l\_fs1\_bytes NUMBER; l\_fs2\_blocks NUMBER; l\_fs2\_bytes NUMBER; l\_fs3\_blocks NUMBER; l\_fs3\_bytes NUMBER; l\_fs4\_blocks NUMBER; l\_fs4\_bytes NUMBER; l\_full\_blocks NUMBER; l\_full\_bytes NUMBER; -- inline procedure to print out numbers nicely formatted -- with a simple label PROCEDURE p ( p\_label IN VARCHAR2, p\_num IN NUMBER ) IS BEGIN dbms\_output.put\_line(rpad(p\_label, 40, '.') || to\_char(p\_num, '999,999,999,999')); END; BEGIN -- this query is executed dynamically in order to allow this procedure -- to be created by a user who has access to DBA\_SEGMENTS/TABLESPACES -- via a role as is customary. -- NOTE: at runtime, the invoker MUST have access to these two -- views! -- this query determines if the object is an ASSM object or not BEGIN EXECUTE IMMEDIATE 'select ts.segment\_space\_management from dba\_segments seg, dba\_tablespaces ts where seg.segment\_name = :p\_segname and (:p\_partition is null or seg.partition\_name = :p\_partition) and seg.owner = :p\_owner and seg.tablespace\_name = ts.tablespace\_name' INTO l\_segment\_space\_mgmt USING p\_segname, p\_partition, p\_partition, p\_owner; EXCEPTION WHEN too\_many\_rows THEN dbms\_output.put\_line('This must be a partitioned table, use p\_partition => '); RETURN; END; -- if the object is in an ASSM tablespace, we must use this API -- call to get space information, otherwise we use the FREE\_BLOCKS -- API for the user-managed segments IF l\_segment\_space\_mgmt = 'AUTO' THEN dbms\_space.space\_usage(p\_owner, p\_segname, p\_type, l\_unformatted\_blocks, l\_unformatted\_bytes, l\_fs1\_blocks, l\_fs1\_bytes, l\_fs2\_blocks, l\_fs2\_bytes, l\_fs3\_blocks, l\_fs3\_bytes, l\_fs4\_blocks, l\_fs4\_bytes, l\_full\_blocks, l\_full\_bytes, p\_partition); p('Unformatted Blocks ', l\_unformatted\_blocks); p('FS1 Blocks (0-25) ', l\_fs1\_blocks); p('FS2 Blocks (25-50) ', l\_fs2\_blocks); p('FS3 Blocks (50-75) ', l\_fs3\_blocks); p('FS4 Blocks (75-100)', l\_fs4\_blocks); p('Full Blocks ', l\_full\_blocks); ELSE dbms\_space.free\_blocks(segment\_owner => p\_owner, segment\_name => p\_segname, segment\_type => p\_type, freelist\_group\_id => 0, free\_blks => l\_free\_blks); p('Free Blocks', l\_free\_blks); END IF; -- and then the unused space API call to get the rest of the -- information dbms\_space.unused\_space(segment\_owner => p\_owner, segment\_name => p\_segname, segment\_type => p\_type, partition\_name => p\_partition, total\_blocks => l\_total\_blocks, total\_bytes => l\_total\_bytes, unused\_blocks => l\_unused\_blocks, unused\_bytes => l\_unused\_bytes, LAST\_USED\_EXTENT\_FILE\_ID => l\_LastUsedExtFileId, LAST\_USED\_EXTENT\_BLOCK\_ID => l\_LastUsedExtBlockId, LAST\_USED\_BLOCK => l\_LAST\_USED\_BLOCK); p('Total Blocks', l\_total\_blocks); p('Total Bytes', l\_total\_bytes); p('Total MBytes', trunc(l\_total\_bytes / 1024 / 1024)); p('Unused Blocks', l\_unused\_blocks); p('Unused Bytes', l\_unused\_bytes); p('Last Used Ext FileId', l\_LastUsedExtFileId); p('Last Used Ext BlockId', l\_LastUsedExtBlockId); p('Last Used Block', l\_LAST\_USED\_BLOCK); END;

七、快捷参考

有关性能优化请参考

[Oracle硬解析与软解析][Oracle]

[共享池的调整与优化(Sharedpool Tuning)][Sharedpool Tuning]

[Buffercache 的调整与优化(一)][Buffercache]

[Oracle表缓存(cachingtable)的使用][Oracle_cachingtable]

有关ORACLE体系结构请参考

[Oracle表空间与数据文件][Oracle 1]

[Oracle密码文件][Oracle 2]

[Oracle参数文件][Oracle 3]

[Oracle联机重做日志文件(ONLINE LOG FILE)][Oracle_ONLINE LOG FILE]

[Oracle控制文件(CONTROLFILE)][Oracle_CONTROLFILE]

[Oracle归档日志][Oracle 4]

[Oracle回滚(ROLLBACK)和撤销(UNDO)][Oracle_ROLLBACK_UNDO]

[Oracle数据库实例启动关闭过程][Oracle 5]

[Oracle10g SGA 的自动化管理][Oracle10g SGA]

[Oracle实例和Oracle数据库(Oracle体系结构)][Oracle_Oracle_Oracle]

有关闪回特性请参考

[Oracle闪回特性(FLASHBACK DATABASE)][Oracle_FLASHBACK DATABASE]

[Oracle闪回特性(FLASHBACK DROP & RECYCLEBIN)][Oracle_FLASHBACK DROP _ RECYCLEBIN]

[Oracle闪回特性(Flashback Query、FlashbackTable)][Oracle_Flashback Query_FlashbackTable]

[Oracle闪回特性(Flashback Version、Flashback Transaction)][Oracle_Flashback Version_Flashback Transaction]

有关基于用户管理的备份和备份恢复的概念请参考

[Oracle冷备份][Oracle 6]

[Oracle热备份][Oracle 7]

[Oracle备份恢复概念][Oracle 8]

[Oracle实例恢复][Oracle 9]

[Oracle基于用户管理恢复的处理][Oracle 10](详细描述了介质恢复及其处理)

[SYSTEM表空间管理及备份恢复][SYSTEM]

[SYSAUX表空间管理及恢复][SYSAUX]

有关RMAN的备份恢复与管理请参考

[RMAN 概述及其体系结构][RMAN]

[RMAN 配置、监控与管理][RMAN 1]

[RMAN 备份详解][RMAN 2]

[RMAN 还原与恢复][RMAN 3]

[RMANcatalog 的创建和使用][RMANcatalog]

[基于catalog 创建RMAN存储脚本][catalog _RMAN]

[基于catalog 的RMAN 备份与恢复][catalog _RMAN 1]

[使用RMAN迁移文件系统数据库到ASM][RMAN_ASM]

[RMAN 备份路径困惑(使用plus archivelog时)][RMAN _plus archivelog]

有关ORACLE故障请参考

[ORA-32004的错误处理][ORA-32004]

[ORA-01658错误][ORA-01658]

[CRS-0215错误处理][CRS-0215]

[ORA-00119，ORA-00132 错误处理][ORA-00119_ORA-00132]

[又一例SPFILE设置错误导致数据库无法启动][SPFILE]

[对参数FAST\_START\_MTTR\_TARGET= 0 的误解及设定][FAST_START_MTTR_TARGET_ 0]

[SPFILE错误导致数据库无法启动(ORA-01565)][SPFILE_ORA-01565]

有关ASM请参考

[创建ASM实例及ASM数据库][ASM_ASM]

[ASM 磁盘、目录的管理][ASM]

[使用 ASMCMD 工具管理ASM目录及文件][ASMCMD _ASM]

有关SQL/PLSQL请参考

[SQLPlus常用命令][SQLPlus]

[替代变量与SQL\*Plus环境设置][SQL_Plus]

[使用Uniread实现SQLplus翻页功能][Uniread_SQLplus]

[SQL 基础*-->SELECT 查询*][SQL _--_SELECT]

[SQL 基础*--> NEW\_VALUE的使用*][SQL _--_ NEW_VALUE]

[SQL 基础*--> 集合运算(UNION与UNION ALL)*][SQL _--_ _UNION_UNION ALL]

[SQL 基础*--> 常用函数*][SQL _--_]

[SQL 基础*--> 视图(CREATEVIEW)*][SQL _--_ _CREATEVIEW]

[SQL 基础*--> 创建和管理表*][SQL _--_ 1]

[SQL 基础*--> 多表查询*][SQL _--_ 2]

[SQL 基础*--> 过滤和排序*][SQL _--_ 3]

[SQL 基础*--> 子查询*][SQL _--_ 4]

[SQL 基础*--> 分组与分组函数*][SQL _--_ 5]

[SQL 基础*--> 层次化查询(STARTBY ... CONNECT BY PRIOR)*][SQL _--_ _STARTBY ... CONNECT BY PRIOR]

[SQL 基础*--> ROLLUP与CUBE运算符实现数据汇总*][SQL _--_ ROLLUP_CUBE]

[PL/SQL*--> 游标*][PL_SQL_--_]

[PL/SQL*--> 异常处理(Exception)*][PL_SQL_--_ _Exception]

[PL/SQL*--> 语言基础*][PL_SQL_--_ 1]

[PL/SQL*--> 流程控制*][PL_SQL_--_ 2]

[PL/SQL*--> PL/SQL记录*][PL_SQL_--_ PL_SQL]

[PL/SQL*--> 包的创建与管理*][PL_SQL_--_ 3]

[PL/SQL*--> 隐式游标(SQL%FOUND)*][PL_SQL_--_ _SQL_FOUND]

[PL/SQL*--> 包重载、初始化*][PL_SQL_--_ 4]

[PL/SQL*--> DBMS\_DDL包的使用*][PL_SQL_--_ DBMS_DDL]

[PL/SQL*--> DML 触发器*][PL_SQL_--_ DML]

[PL/SQL*--> INSTEAD OF 触发器*][PL_SQL_--_ INSTEAD OF]

[PL/SQL*--> 存储过程*][PL_SQL_--_ 5]

[PL/SQL*--> 函数*][PL_SQL_--_ 6]

[PL/SQL*--> 动态SQL*][PL_SQL_--_ _SQL]

[PL/SQL*--> 动态SQL的常见错误*][PL_SQL_--_ _SQL 1]

有关ORACLE其它特性

[Oracle常用目录结构(10g)][Oracle_10g]

[使用OEM,SQL\*Plus,iSQL\*Plus 管理Oracle实例][OEM_SQL_Plus_iSQL_Plus _Oracle]

[日志记录模式(LOGGING、FORCE LOGGING 、NOLOGGING)][LOGGING_FORCE LOGGING _NOLOGGING]

[表段、索引段上的LOGGING与NOLOGGING][LOGGING_NOLOGGING]

[OralceOMF 功能详解][OralceOMF]

[Oracle用户、对象权限、系统权限 ][Oracle_]

[Oracle角色、配置文件][Oracle 11]

[Oracle分区表][Oracle 12]

[Oracle外部表][Oracle 13]

[使用外部表管理Oracle 告警日志(ALAERT\_$SID.LOG)][Oracle _ALAERT_SID.LOG]

[簇表及簇表管理(Index clustered tables)][Index clustered tables]

[数据泵 EXPDP 导出工具的使用][EXPDP]

[数据泵 IMPDP 导入工具的使用][IMPDP]

[导入导出 Oracle 分区表数据][Oracle 14]

[SQL\*Loader使用方法][SQL_Loader]

[启用用户进程跟踪][Link 1]

[配置非默认端口的动态服务注册][Link 2]

[配置ORACLE 客户端连接到数据库][ORACLE]

[systemsys，sysoper sysdba 的区别][systemsys_sysoper sysdba]

[ORACLE\_SID、DB\_NAME、INSTANCE\_NAME、DB\_DOMIAN、GLOBAL\_NAME][ORACLE_SID_DB_NAME_INSTANCE_NAME_DB_DOMIAN_GLOBAL_NAME]

[Oracle补丁全集 (Oracle 9i 10g 11g Path)][Oracle_ _Oracle 9i 10g 11g Path]

[Oracle10.2.0.1 升级到10.2.0.4][Oracle10.2.0.1 _10.2.0.4]

[Oracle彻底 kill session][Oracle_ kill session]

[Oracle]: http://blog.csdn.net/robinson_0612/archive/2011/02/19/6195483.aspx
[Sharedpool Tuning]: http://blog.csdn.net/robinson_0612/archive/2011/02/25/6208268.aspx
[Buffercache]: http://blog.csdn.net/robinson_0612/archive/2011/02/25/6208594.aspx
[Oracle_cachingtable]: http://blog.csdn.net/robinson_0612/archive/2011/03/06/6226767.aspx
[Oracle 1]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611738.aspx
[Oracle 2]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611672.aspx
[Oracle 3]: http://blog.csdn.net/robinson_0612/archive/2010/05/05/5559174.aspx
[Oracle_ONLINE LOG FILE]: http://blog.csdn.net/robinson_0612/archive/2010/07/20/5749556.aspx
[Oracle_CONTROLFILE]: http://blog.csdn.net/robinson_0612/archive/2010/07/15/5737527.aspx
[Oracle 4]: http://blog.csdn.net/robinson_0612/archive/2010/08/03/5784713.aspx
[Oracle_ROLLBACK_UNDO]: http://blog.csdn.net/robinson_0612/archive/2010/07/13/5731158.aspx
[Oracle 5]: http://blog.csdn.net/robinson_0612/archive/2010/04/29/5542983.aspx
[Oracle10g SGA]: http://blog.csdn.net/robinson_0612/archive/2010/04/27/5534832.aspx
[Oracle_Oracle_Oracle]: http://blog.csdn.net/robinson_0612/archive/2010/04/26/5529239.aspx
[Oracle_FLASHBACK DATABASE]: http://blog.csdn.net/robinson_0612/archive/2010/12/27/6100429.aspx
[Oracle_FLASHBACK DROP _ RECYCLEBIN]: http://blog.csdn.net/robinson_0612/archive/2010/12/29/6105327.aspx
[Oracle_Flashback Query_FlashbackTable]: http://blog.csdn.net/robinson_0612/archive/2011/01/02/6112607.aspx
[Oracle_Flashback Version_Flashback Transaction]: http://blog.csdn.net/robinson_0612/archive/2011/01/02/6112981.aspx
[Oracle 6]: http://blog.csdn.net/robinson_0612/archive/2010/08/05/5791597.aspx
[Oracle 7]: http://blog.csdn.net/robinson_0612/archive/2010/08/16/5816012.aspx
[Oracle 8]: http://blog.csdn.net/robinson_0612/archive/2010/08/05/5791585.aspx
[Oracle 9]: http://blog.csdn.net/robinson_0612/archive/2010/07/27/5768233.aspx
[Oracle 10]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041217.aspx
[SYSTEM]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041207.aspx
[SYSAUX]: http://blog.csdn.net/robinson_0612/archive/2010/08/13/5810732.aspx
[RMAN]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032525.aspx
[RMAN 1]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032597.aspx
[RMAN 2]: http://blog.csdn.net/robinson_0612/archive/2010/11/24/6032739.aspx
[RMAN 3]: http://blog.csdn.net/robinson_0612/archive/2010/11/28/6041247.aspx
[RMANcatalog]: http://blog.csdn.net/robinson_0612/archive/2010/11/29/6043649.aspx
[catalog _RMAN]: http://blog.csdn.net/robinson_0612/archive/2010/12/13/6073020.aspx
[catalog _RMAN 1]: http://blog.csdn.net/robinson_0612/archive/2010/12/13/6073069.aspx
[RMAN_ASM]: http://blog.csdn.net/robinson_0612/archive/2011/05/30/6453954.aspx
[RMAN _plus archivelog]: http://blog.csdn.net/robinson_0612/archive/2011/05/12/6414338.aspx
[ORA-32004]: http://blog.csdn.net/robinson_0612/archive/2011/02/19/6195475.aspx
[ORA-01658]: http://blog.csdn.net/robinson_0612/archive/2011/03/14/6249202.aspx
[CRS-0215]: http://blog.csdn.net/robinson_0612/archive/2011/04/05/6303583.aspx
[ORA-00119_ORA-00132]: http://blog.csdn.net/robinson_0612/archive/2011/05/05/6396989.aspx
[SPFILE]: http://blog.csdn.net/robinson_0612/archive/2010/08/03/5784736.aspx
[FAST_START_MTTR_TARGET_ 0]: http://blog.csdn.net/robinson_0612/archive/2010/08/02/5782516.aspx
[SPFILE_ORA-01565]: http://blog.csdn.net/robinson_0612/archive/2010/07/29/5774795.aspx
[ASM_ASM]: http://blog.csdn.net/robinson_0612/archive/2010/12/16/6080659.aspx
[ASM]: http://blog.csdn.net/robinson_0612/archive/2011/01/13/6134071.aspx
[ASMCMD _ASM]: http://blog.csdn.net/robinson_0612/archive/2011/01/13/6134163.aspx
[SQLPlus]: http://blog.csdn.net/robinson_0612/archive/2010/04/06/5454382.aspx
[SQL_Plus]: http://blog.csdn.net/robinson_0612/archive/2010/12/18/6084376.aspx
[Uniread_SQLplus]: http://blog.csdn.net/robinson_0612/archive/2010/03/30/5431655.aspx
[SQL _--_SELECT]: http://blog.csdn.net/robinson_0612/archive/2010/04/15/5487668.aspx
[SQL _--_ NEW_VALUE]: http://blog.csdn.net/robinson_0612/archive/2011/02/18/6192944.aspx
[SQL _--_ _UNION_UNION ALL]: http://blog.csdn.net/robinson_0612/archive/2010/05/20/5611716.aspx
[SQL _--_]: http://blog.csdn.net/robinson_0612/archive/2010/04/16/5495170.aspx
[SQL _--_ _CREATEVIEW]: http://blog.csdn.net/robinson_0612/archive/2010/05/28/5630426.aspx
[SQL _--_ 1]: http://blog.csdn.net/robinson_0612/archive/2010/06/23/5689199.aspx
[SQL _--_ 2]: http://blog.csdn.net/robinson_0612/archive/2010/05/06/5563199.aspx
[SQL _--_ 3]: http://blog.csdn.net/robinson_0612/archive/2010/04/15/5487992.aspx
[SQL _--_ 4]: http://blog.csdn.net/robinson_0612/archive/2010/05/14/5592002.aspx
[SQL _--_ 5]: http://blog.csdn.net/robinson_0612/archive/2010/05/05/5559110.aspx
[SQL _--_ _STARTBY ... CONNECT BY PRIOR]: http://blog.csdn.net/robinson_0612/archive/2010/05/22/5616877.aspx
[SQL _--_ ROLLUP_CUBE]: http://blog.csdn.net/robinson_0612/archive/2010/06/01/5640031.aspx
[PL_SQL_--_]: http://blog.csdn.net/robinson_0612/archive/2010/12/15/6078622.aspx
[PL_SQL_--_ _Exception]: http://blog.csdn.net/robinson_0612/archive/2010/12/16/6080119.aspx
[PL_SQL_--_ 1]: http://blog.csdn.net/robinson_0612/archive/2010/12/08/6063399.aspx
[PL_SQL_--_ 2]: http://blog.csdn.net/robinson_0612/archive/2010/12/08/6063422.aspx
[PL_SQL_--_ PL_SQL]: http://blog.csdn.net/robinson_0612/archive/2010/12/18/6084390.aspx
[PL_SQL_--_ 3]: http://blog.csdn.net/robinson_0612/archive/2010/12/18/6084475.aspx
[PL_SQL_--_ _SQL_FOUND]: http://blog.csdn.net/robinson_0612/archive/2010/12/22/6092066.aspx
[PL_SQL_--_ 4]: http://blog.csdn.net/robinson_0612/archive/2010/12/22/6092097.aspx
[PL_SQL_--_ DBMS_DDL]: http://blog.csdn.net/robinson_0612/archive/2010/12/25/6098248.aspx
[PL_SQL_--_ DML]: http://blog.csdn.net/robinson_0612/archive/2010/12/25/6098258.aspx
[PL_SQL_--_ INSTEAD OF]: http://blog.csdn.net/robinson_0612/archive/2010/12/25/6098263.aspx
[PL_SQL_--_ 5]: http://blog.csdn.net/robinson_0612/archive/2010/12/08/6063434.aspx
[PL_SQL_--_ 6]: http://blog.csdn.net/robinson_0612/archive/2010/12/11/6069531.aspx
[PL_SQL_--_ _SQL]: http://blog.csdn.net/robinson_0612/archive/2011/01/05/6118010.aspx
[PL_SQL_--_ _SQL 1]: http://blog.csdn.net/robinson_0612/archive/2011/01/05/6118049.aspx
[Oracle_10g]: http://blog.csdn.net/robinson_0612/archive/2010/05/29/5633093.aspx
[OEM_SQL_Plus_iSQL_Plus _Oracle]: http://blog.csdn.net/robinson_0612/archive/2010/04/26/5529260.aspx
[LOGGING_FORCE LOGGING _NOLOGGING]: http://blog.csdn.net/robinson_0612/archive/2011/01/12/6130866.aspx
[LOGGING_NOLOGGING]: http://blog.csdn.net/robinson_0612/archive/2011/01/12/6131176.aspx
[OralceOMF]: http://blog.csdn.net/robinson_0612/archive/2010/04/12/5478323.aspx
[Oracle_]: http://blog.csdn.net/robinson_0612/archive/2010/06/23/5688875.aspx
[Oracle 11]: http://blog.csdn.net/robinson_0612/archive/2010/06/23/5688997.aspx
[Oracle 12]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925572.aspx
[Oracle 13]: http://blog.csdn.net/robinson_0612/archive/2010/12/15/6078481.aspx
[Oracle _ALAERT_SID.LOG]: http://blog.csdn.net/robinson_0612/archive/2011/02/18/6192979.aspx
[Index clustered tables]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925501.aspx
[EXPDP]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925592.aspx
[IMPDP]: http://blog.csdn.net/robinson_0612/archive/2010/10/08/5926276.aspx
[Oracle 14]: http://blog.csdn.net/robinson_0612/archive/2011/03/13/6246738.aspx
[SQL_Loader]: http://blog.csdn.net/robinson_0612/archive/2010/10/08/5926296.aspx
[Link 1]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925564.aspx
[Link 2]: http://blog.csdn.net/robinson_0612/archive/2010/10/07/5925526.aspx
[ORACLE]: http://blog.csdn.net/robinson_0612/archive/2010/09/30/5917103.aspx
[systemsys_sysoper sysdba]: http://blog.csdn.net/robinson_0612/archive/2010/11/05/5989565.aspx
[ORACLE_SID_DB_NAME_INSTANCE_NAME_DB_DOMIAN_GLOBAL_NAME]: http://blog.csdn.net/robinson_0612/archive/2010/09/30/5917082.aspx
[Oracle_ _Oracle 9i 10g 11g Path]: http://blog.csdn.net/robinson_0612/archive/2011/04/06/6304124.aspx
[Oracle10.2.0.1 _10.2.0.4]: http://blog.csdn.net/robinson_0612/archive/2011/05/05/6396783.aspx
[Oracle_ kill session]: http://blog.csdn.net/robinson_0612/archive/2011/05/23/6439019.aspx