Oracle Data Storage Internals
2009-08-25 09:39:54| 分类:
dbms
| 标签:
|举报
|字号大中小 订阅
O-AI-DSI Copyright Trivadis AG Christian Antognini
Table of Contents
1 Identifiers
1.1 RDBA
1.2 ROWID
1.3 SCN
1.4 XID
1.5 UBA
1.6 Review Questions
2 Layouts
2.1 File
2.2 Segment with Freelist Management
2.3 Segment with Automatic Segment Space Management
2.4 Review Questions
3 Inspect Blocks
3.1 Dirty Blocks
3.2 Formatted Block Dumps
3.3 BBED
3.4 Raw Blocks Dumps
3.5 Review Questions
4 Common Block Structures
4.1 Common Block Structures
4.2 Common Block Header
4.3 Common Block Tail
4.4 Review Questions
5 Freelists Segment Space Management
5.1 Concepts
5.2 Header Blocks
5.3 Segment Control Header
5.4 Extent Map Header
5.5 Extent Map
5.6 Freelist Header
5.7 Freelist
5.8 Waits
5.9 Review Questions
6 Automatic Segment Space Management
6.1 Concepts
6.2 Header Blocks
6.3 Automatic vs. Freelists Segment Space Management
6.4 Review Questions
7 Transaction Layer
7.1 Concepts
7.2 Transaction Layer
7.3 Transaction Header
7.4 Interested Transaction List
7.5 ITL Waits
7.6 Review Questions
8 Undo
8.1 Concepts
8.2 Undo Blocks
8.3 Retention Table
8.4 Transaction Control Header
8.5 Transaction Table
8.6 Undo Block Header
8.7 Undo Records Directory
8.8 Undo Record
8.9 Review Questions
9 Data
9.1 Concepts
9.2 Data Header
9.3 Table Directory
9.4 Row Directory
9.5 Row Format
9.6 Reorganizations
9.7 Compression
9.8 Review Questions
10 Index
10.1 Concepts
10.2 Index Area
10.3 Branch Block Header and Key
10.4 Leaf Block Header and Key
10.5 Splits
10.6 Free Space
10.7 Reorganizations
10.8 Bitmap
10.9 Review Questions
11 Corruptions
11.1 Types of Corruptions
11.2 Block Checksum
11.3 Block Checking
11.4 Identifying Corruptions
11.5 Repairing Corruptions
11.6 Review Questions
评论这张
转发至微博
转发至微博
评论