oracle 查看段头是那个块,oracle段头+位图

最新推荐文章于 2024-04-05 06:08:58 发布

蕙风如薰

最新推荐文章于 2024-04-05 06:08:58 发布

阅读量250

点赞数

文章标签： oracle 查看段头是那个块

SQL> select OBJ#,DATAOBJ#,TS#,block#,FILE#,BOBJ#,TAB#,COLS,CLUCOLS from tab$ where OBJ#=51146 or OBJ#=51148 or OBJ#=51150 or OBJ#=51151;

OBJ# DATAOBJ# TS# BLOCK# FILE# BOBJ# TAB# COLS CLUCOLS

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

51146 51146 4 11 4 3

51148 51148 4 27 4 8

51150 51150 4 43 4 4

51151 51151 4 51 4 3

SQL> select dbms_utility.DATA_BLOCK_ADDRESS_FILE(to_number('240001e', 'xxxxxxxxxx')) file#, dbms_utility.DATA_BLOCK_ADDRESS_BLOCK(to_number('240001e', 'xxxxxxxxxx')) block# from dual;

FILE# BLOCK#

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

9 30

SQL> select dbms_utility.DATA_BLOCK_ADDRESS_FILE(to_number('0100000a', 'xxxxxxxxxx')) file#, dbms_utility.DATA_BLOCK_ADDRESS_BLOCK(to_number('240001e', 'xxxxxxxxxx')) block# from dual;

FILE# BLOCK#

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

4 30

SQL> select dbms_utility.DATA_BLOCK_ADDRESS_FILE(to_number('0100000a', 'xxxxxxxxxx')) file#, dbms_utility.DATA_BLOCK_ADDRESS_BLOCK(to_number('0100000a', 'xxxxxxxxxx')) block# from dual;

FILE# BLOCK#

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

4 10

SQL> select dbms_utility.DATA_BLOCK_ADDRESS_FILE(to_number('01000009','xxxxxxxxxx')) file#,

2 dbms_utility.DATA_BLOCK_ADDRESS_BLOCK(to_number('01000009','xxxxxxxxxx')) block# from dual;

FILE# BLOCK#

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

4 9

SQL>

SQL> select dbms_utility.DATA_BLOCK_ADDRESS_FILE(to_number('01000011','xxxxxxxxxx')) file#,dbms_utility.DATA_BLOCK_ADDRESS_BLOCK(to_number('01000011','xxxxxxxxxx')) block# from dual;

FILE# BLOCK#

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

4 17

CF055F0 00000000 00000000 00000000 BFDB2302 [.............#..]

Extent Control Header

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

Extent Header:: spare1: 0 spare2: 0 #extents: 1 #blocks: 8

last map 0x00000000 #maps: 0 offset: 2716

Highwater:: 0x01000011 ext#: 0 blk#: 8 ext size: 8 ------file 4 block 17

#blocks in seg. hdr's freelists: 0

#blocks below: 5

mapblk 0x00000000 offset: 0

Unlocked

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

Low HighWater Mark :

Highwater:: 0x01000011 ext#: 0 blk#: 8 ext size: 8

#blocks in seg. hdr's freelists: 0

#blocks below: 5

mapblk 0x00000000 offset: 0

Level 1 BMB for High HWM block: 0x01000009

Level 1 BMB for Low HWM block: 0x01000009

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

Segment Type: 1 nl2: 1 blksz: 8192 fbsz: 0

L2 Array start offset: 0x00001434

First Level 3 BMB: 0x00000000

L2 Hint for inserts: 0x0100000a

Last Level 1 BMB: 0x01000009 --------file 4 block 9

Last Level II BMB: 0x0100000a---------file 4 block 10

Last Level III BMB: 0x00000000---------空

Map Header:: next 0x00000000 #extents: 1 obj#: 51146 flag: 0x10000000

Inc # 0

Extent Map

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

0x01000009 length: 8

Auxillary Map

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

Extent 0 : L1 dba: 0x01000009 Data dba: 0x0100000c

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

Second Level Bitmap block DBAs

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

DBA 1: 0x0100000a

End dump data blocks tsn: 4 file#: 4 minblk 11 maxblk 11

SQL> alter table scott.DEPT allocate extent (size 20m);

Table altered.

SQL> alter system checkpoint;

System altered.

SQL> alter system checkpoint;

System altered.

SQL> alter system dump datafile 4 block 11;

System altered.

SQL> select SEGMENT_NAME,EXTENT_ID, FILE_ID,BLOCK_ID,BLOCKS from dba_extents where FILE_ID=4 and SEGMENT_NAME='DEPT';

SEGMENT_NAME EXTENT_ID FILE_ID BLOCK_ID BLOCKS

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

DEPT 0 4 9 8

DEPT 1 4 137 128

DEPT 2 4 265 128

DEPT 3 4 393 128

DEPT 4 4 521 128

DEPT 5 4 649 128

DEPT 6 4 777 128

DEPT 7 4 905 128

DEPT 8 4 1033 128

DEPT 9 4 1161 128

DEPT 10 4 1289 128

DEPT 11 4 1417 128

DEPT 12 4 1545 128

DEPT 13 4 1673 128

DEPT 14 4 1801 128

DEPT 15 4 1929 128

DEPT 16 4 2057 128

DEPT 17 4 2185 128

DEPT 18 4 2313 128

DEPT 19 4 2441 128

DEPT 20 4 2569 128

21 rows selected.

SQL>

Extent Control Header

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

Extent Header:: spare1: 0 spare2: 0 #extents: 21 #blocks: 2568

last map 0x00000000 #maps: 0 offset: 2716

Highwater:: 0x01000011 ext#: 0 blk#: 8 ext size: 8

#blocks in seg. hdr's freelists: 0

#blocks below: 5

mapblk 0x00000000 offset: 0

Disk Lock:: Locked by xid: 0x0001.00a.00000324

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

Low HighWater Mark :

Highwater:: 0x01000011 ext#: 0 blk#: 8 ext size: 8

#blocks in seg. hdr's freelists: 0

#blocks below: 5

mapblk 0x00000000 offset: 0

Level 1 BMB for High HWM block: 0x01000009

Level 1 BMB for Low HWM block: 0x01000009

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

Segment Type: 1 nl2: 1 blksz: 8192 fbsz: 0

L2 Array start offset: 0x00001434

First Level 3 BMB: 0x00000000

L2 Hint for inserts: 0x0100000a

Last Level 1 BMB: 0x01000a0a

Last Level II BMB: 0x0100000a

Last Level III BMB: 0x00000000

Map Header:: next 0x00000000 #extents: 21 obj#: 51146 flag: 0x10000000

Inc # 0

Extent Map

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

0x01000009 length: 8

0x01000089 length: 128

0x01000109 length: 128

0x01000189 length: 128

0x01000209 length: 128

0x01000289 length: 128

0x01000309 length: 128

0x01000389 length: 128

0x01000409 length: 128

0x01000489 length: 128

0x01000509 length: 128

0x01000589 length: 128

0x01000609 length: 128

0x01000689 length: 128

0x01000709 length: 128

0x01000789 length: 128

0x01000809 length: 128

0x01000889 length: 128

0x01000909 length: 128

0x01000989 length: 128

0x01000a09 length: 128

Auxillary Map

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

Extent 0 : L1 dba: 0x01000009 Data dba: 0x0100000c

Extent 1 : L1 dba: 0x01000089 Data dba: 0x0100008b

Extent 2 : L1 dba: 0x01000109 Data dba: 0x0100010b

Extent 3 : L1 dba: 0x01000189 Data dba: 0x0100018b

Extent 4 : L1 dba: 0x01000209 Data dba: 0x0100020b

Extent 5 : L1 dba: 0x01000289 Data dba: 0x0100028b

Extent 6 : L1 dba: 0x01000309 Data dba: 0x0100030b

Extent 7 : L1 dba: 0x01000389 Data dba: 0x0100038b

Extent 8 : L1 dba: 0x01000409 Data dba: 0x0100040b

Extent 9 : L1 dba: 0x01000489 Data dba: 0x0100048b

Extent 10 : L1 dba: 0x01000509 Data dba: 0x0100050b

Extent 11 : L1 dba: 0x01000589 Data dba: 0x0100058b

Extent 12 : L1 dba: 0x01000609 Data dba: 0x0100060b

Extent 13 : L1 dba: 0x01000689 Data dba: 0x0100068b

Extent 14 : L1 dba: 0x01000709 Data dba: 0x0100070b

Extent 15 : L1 dba: 0x01000789 Data dba: 0x0100078b

Extent 16 : L1 dba: 0x01000809 Data dba: 0x0100080b

Extent 17 : L1 dba: 0x01000889 Data dba: 0x0100088b

Extent 18 : L1 dba: 0x01000909 Data dba: 0x0100090b

Extent 19 : L1 dba: 0x01000989 Data dba: 0x0100098b

Extent 20 : L1 dba: 0x01000a09 Data dba: 0x01000a0b

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

Second Level Bitmap block DBAs

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

DBA 1: 0x0100000a

End dump data blocks tsn: 4 file#: 4 minblk 11 maxblk 11

SQL> select to_char(8,'xxxxxxxxxxxx') from dual;

TO_CHAR(8,'XXXXXXXXXXXX')

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

SQL> select to_char(128,'xxxxxxxxxxxx') from dual;

TO_CHAR(128,'XXXXXXXXXXXX'

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