
平臺論壇博客文庫

› 論壇 › 數(shù)據(jù)庫技術 › Oracle › Oracle里段頭的類型

Oracle里段頭的類型 [復制鏈接]

gunguymadman

富足長樂

論壇徽章:: 0

電梯直達

1樓 [收藏(0)] [報告]

發(fā)表于 2011-02-14 13:11 |只看該作者 |倒序瀏覽

首先什么是段頭？

The segment header is the header block of the first extent of a segment. In Free List Managed (FLM) segments the header block is always the first block of a segment. In Automatic Segment Space Managed (ASSM) segments, the bitmap blocks always appear before the header block within the first extent of the segment.

The segment header contains information on the extents allocated to the segment and free space within the segment.

接著我們來看oracle里段頭的具體類型：

0x01
undo segment header

0x0b
data file header

0x0c
data segment header with FLG blocks

0x0e
unlimited undo segment header

0x0f
unlimited save undo segment header

0x10
unlimited data segment header

0x11
unlimited data segment header with FLG blocks

0x12
extent map block

0x17
bitmapped segment header

0x1d
bitmapped file space header

0x20
first level bitmap block

0x21
second level bitmap block

0x22
third level bitmap block

0x23
Pagetable segment header block

0x24
Pagetable extent map block

0x25
System Managed Undo Extent Map Block

然后我們來看一個ASSM的實例：

SQL> create tablespace testlmt datafile '/dras20/astca/testlmt01.dbf' size 10M extent management local uniform size 1m segment space management auto;

Tablespace created

SQL> create table testlmttb tablespace testlmt as select * from dba_objects;

Table created

SQL> select extent_id,file_id,block_id,bytes from dba_extents where segment_name='TESTLMTTB';

EXTENT_ID
FILE_ID
BLOCK_ID
BYTES

---------- ---------- ---------- ----------

0
138

9
1048576

1
138
137
1048576

2
138
265
1048576

3
138
393
1048576

1、datafile header，即段頭類型為0x0b

BBED> set file 138

FILE#
138

BBED> set block 1

BLOCK#
1

BBED> dump

File: /dras20/astca/testlmt01.dbf (138)

Block: 1
Offsets:
0 to
511
Dba:0x22800001

------------------------------------------------------------------------

0b020000 22800001 00000000 00000104 4bbb0000 09200000 08000000 df7fd2dd

41535443 41000000 000102df 00000500 00002000 008a0003 00000000 00000000

......省略顯示部分內容

00000000 00000000 00000000 00000059 00075445 53544c4d 54000000 00000000

<32 bytes per line>

2、bitmapped file space header，即段頭類型為0x1d

BBED> set block 2

BLOCK#
2

BBED> dump

File: /dras20/astca/testlmt01.dbf (138)

Block: 2
Offsets:
0 to
511

Dba:0x22800002

------------------------------------------------------------------------

1d020000 22800002 aa35c791 00080204 8a370000 0000008a 00000080 00000500

00000001 00000000 00000000 00000007 00000488 00000004 00000005 00000000

......省略顯示部分內容

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

3、ASSM里的first level bitmap block，即L1 BMB，段頭類型為0x20

BBED> set block 9

BLOCK#
9

BBED> dump

File: /dras20/astca/testlmt01.dbf (138)

Block: 9

Offsets:
0 to
511
Dba:0x22800009

------------------------------------------------------------------------

20020000 22800009 aa35c793 00080304 8ef60000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

......省略顯示部分內容

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

這里Block 137、138、265、266、393、394也是L1 BMB。

4、ASSM里的second level bitmap block，即L2 BMB，段頭類型為0x21

BBED> set block 11

BLOCK#
11

BBED> dump

File: /dras20/astca/testlmt01.dbf (138)

Block: 11
Offsets:
0 to
511
Dba:0x2280000b

------------------------------------------------------------------------

21020000 2280000b aa35c793 00080804 a63a0000 00000000 00000000 00000000

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

......省略顯示部分內容

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

文庫|博客

沃趣科技-Oracle ASM系列-第七篇：了解ASM文件extent的分布情況.docx
Oracle 12c系列(2)PDB的創(chuàng)建.docx
沃趣科技-Oracle ASM系列-第十八篇：ASM 4號文件——Continuing Operations Directory.docx
沃趣科技-Oracle ASM系列-第十六篇：ASM 2號文件——磁盤目錄.docx
沃趣科技-Oracle ASM系列-第十五篇：ASM 3號文件——Active Change Directory.docx
redis源碼閱讀補充說明以及SDS的一點補充
mysql動態(tài)sql批量刪除數(shù)據(jù)
redis源碼閱讀之a(chǎn)e_evport

gunguymadman

富足長樂

論壇徽章:: 0

2樓 [報告]

發(fā)表于 2011-02-14 13:12 |只看該作者

5、ASSM里的Pagetable segment header block，即大家從dba_segments里select出來的ASSM下的"段頭"，段頭類型為0x23

SQL> select HEADER_FILE,HEADER_BLOCK from dba_segments where segment_name='TESTLMTTB';

HEADER_FILE HEADER_BLOCK

----------- ------------

138
12

BBED> set block 12

BLOCK#
12

BBED> dump

File: /dras20/astca/testlmt01.dbf (138)

Block: 12
Offsets:
0 to
511
Dba:0x2280000c

------------------------------------------------------------------------

23020000 2280000c aa35c797 00080104 c59e0000 00000000 00000000 00000000

00000000 00000004 00000200 0a9c0000 00000003 0000004b 00000080 228001d4

......省略顯示部分內容

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

最后我們來看一個MSSM的實例：

因為是9i，所以system表空間就是MSSM。

6、unlimited undo segment header，其實就是系統(tǒng)回滾段的段頭，段頭類型為0x0e

SQL> select HEADER_FILE,HEADER_BLOCK from dba_segments where segment_name='SYSTEM';

HEADER_FILE HEADER_BLOCK

----------- ------------

1
9

BBED> set file 1

FILE#
1

BBED> set block 9

BLOCK#
9

BBED> dump

File: /dras11/oradata/astca/system01.dbf (1)

Block: 9
Offsets:
0 to
511
Dba:0x00400009

------------------------------------------------------------------------

0e020000 00400009 aa340432 00080104 cc3f0000 00000000 00000000 00000000

00000000 00000006 0000002f 10200000 00000001 00000006 00000008 00400017

......省略顯示部分內容

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

7、MSSM里的unlimited data segment header，即大家從dba_segments里select出來的MSSM下的"段頭"，段頭類型為0x10

SQL> select HEADER_FILE,HEADER_BLOCK from dba_segments where segment_name='OBJ$';

HEADER_FILE HEADER_BLOCK

----------- ------------

1
121

BBED> set file 1

FILE#
1

BBED> set block 121

BLOCK#
121

BBED> map /v

File: /dras11/oradata/astca/system01.dbf (1)

Block: 121
Dba:0x00400079

------------------------------------------------------------

Unlimited Data Segment Header

struct kcbh, 20 bytes
@0

ub1 type_kcbh

@0

......省略顯示部分內容

ub2 spare3_kcbh
@18

struct ktech, 72 bytes
@20

ub4 spare1_ktech
@20

......省略顯示部分內容

ub4 flag_ktech

@88

struct ktemh, 16 bytes
@92

ub4 count_ktemh
@92

ub4 next_ktemh
@96

ub4 obj_ktemh
@100

ub4 flag_ktemh
@104

struct ktetb[19], 152 bytes
@108

ub4 ktetbdba
@108

ub4 ktetbnbk
@112

......省略顯示部分內容

ub4 tailchk

@8188

BBED> set offset 96

OFFSET
96

BBED> dump

File: /dras11/oradata/astca/system01.dbf (1)

Block: 121
Offsets:
96 to
607
Dba:0x00400079

------------------------------------------------------------------------

00000000 00000012 40000000 0040007a 00000007 00401169 00000008 004011f9

00000008 00401309 00000008 00401661 00000008 00402049 00000008 00403191

......省略顯示部分內容

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

BBED> set offset 0

OFFSET
0

BBED> dump

File: /dras11/oradata/astca/system01.dbf (1)

Block: 121
Offsets:
0 to
511
Dba:0x00400079

------------------------------------------------------------------------

10020000 00400079 aa2de25f 00080104 e69d0000 00000000 00000000 00000000

00000000 00000013 000001ff 10200000 00000012 00000014 00000080 0040d91d

......省略顯示部分內容

00000000 00000000 00000000 00000000 00000000 00000000 00000000 00000000

<32 bytes per line>

實戰(zhàn)分享：從技術角度談機器學習入門| 【大話IT】RadonDB低門檻向MySQL集群下戰(zhàn)書 | ChinaUnix打賞功能已上線！ | 新一代分布式關系型數(shù)據(jù)庫RadonDB知多少？

renxiao2003

巨富豪門

論壇徽章:: 59

操作系統(tǒng)版塊每日發(fā)帖之星
日期:2015-07-20 11:05:36

數(shù)據(jù)庫技術版塊每日發(fā)帖之星
日期:2015-07-20 11:05:43

3樓 [報告]

發(fā)表于 2011-02-14 13:40 |只看該作者

都在搞高興的內容（此處略掉60字）

實戰(zhàn)分享：從技術角度談機器學習入門| 【大話IT】RadonDB低門檻向MySQL集群下戰(zhàn)書 | ChinaUnix打賞功能已上線！ | 新一代分布式關系型數(shù)據(jù)庫RadonDB知多少？

gunguymadman

富足長樂

論壇徽章:: 0

4樓 [報告]

發(fā)表于 2011-02-14 14:01 |只看該作者

http://dbsnake.com/2009/09/oracle-seg-hdr-type.html
看原文吧轉的有些亂

實戰(zhàn)分享：從技術角度談機器學習入門| 【大話IT】RadonDB低門檻向MySQL集群下戰(zhàn)書 | ChinaUnix打賞功能已上線！ | 新一代分布式關系型數(shù)據(jù)庫RadonDB知多少？

返回列表

Chinaunix › 論壇 › 數(shù)據(jù)庫技術 › Oracle › Oracle里段頭的類型

積分 0, 距離下一級還需積分

亚洲av成人无遮挡网站在线观看,少妇性bbb搡bbb爽爽爽,亚洲av日韩精品久久久久久,兔费看少妇性l交大片免费,无码少妇一区二区三区

Oracle里段頭的類型 [復制鏈接]