- 16 - 序言
3.3.3
锁存器和内部锁定
(
入队
).......................................................................................................................88
3.3.4
手动封锁和用户自定义锁定
.................................................................................................................88
3.4 什么是并行控制.............................................................................................................................................89
3.4.1
事务隔离等级
.........................................................................................................................................89
3.4.2 READ UNCOMMITTED
隔离等级
.........................................................................................................90
3.4.3 READ COMMITTED
隔离等级
...............................................................................................................91
3.4.4 REPEATABLE READ
隔离等级
...............................................................................................................93
3.4.5 SERIALIZABLE
隔离等级
.......................................................................................................................95
3.4.6
只读事务
.................................................................................................................................................96
3.5 小结.................................................................................................................................................................96
第 4 章 事务 .............................................................................................................................................................98
4.1 事务控制语句.................................................................................................................................................98
4.2 完整性约束和事务.......................................................................................................................................102
4.3 处理事务的不良习惯...................................................................................................................................104
4.4 分布式事务...................................................................................................................................................109
4.5 重做和回滚................................................................................................................................................... 111
4.6 小结............................................................................................................................................................... 114
第 5 章 重做和回滚 ............................................................................................................................................... 115
5.1 重做............................................................................................................................................................... 115
5.1.1 COMMIT ................................................................................................................................................ 116
5.1.2
回滚
.......................................................................................................................................................120
5.1.3
产生多少重做
.......................................................................................................................................121
5.1.4
能够不让重做日志产生吗
...................................................................................................................130
5.1.5
不能分配一个新日志
...........................................................................................................................133
5.1.6
块清除
...................................................................................................................................................134
5.1.7
日志竞争
...............................................................................................................................................136
5.1.8
临时表和重做
/
回滚
..............................................................................................................................138
5.1.9
分析重做
...............................................................................................................................................140
5.2 回滚...............................................................................................................................................................141
5.2.1
什么产生最多
/
最少的撤消
..................................................................................................................141
5.2.2 SET TRANSACTION...............................................................................................................................141
5.2.3 “ORA-01555: Snapshot too old”.........................................................................................................142
5.3 小结...............................................................................................................................................................150
第 6 章 数据库表 ...................................................................................................................................................151
6.1 表的类型.......................................................................................................................................................151
6.2 术语...............................................................................................................................................................152
6.2.1
高水标记
...............................................................................................................................................152
6.2.2
自由列表
...............................................................................................................................................153
6.2.3 PCTFREE
和
PCTUSED........................................................................................................................155
6.2.4 INITIAL, NEXT
和
PCTINCREASE .......................................................................................................160
6.2.5 MINEXTENTS
和
MAXEXTENTS..........................................................................................................161
6.2.6 LOGGING
和
NOLOGGING .................................................................................................................161
6.2.7 INITRANS
和
MAXTRANS.....................................................................................................................161
6.3 堆组织表.......................................................................................................................................................161