[20150512]转储表空间位图信息.txt
--曾经在探究系统管理表空间位图区分布存在许多疑问,参考如下链接:
http://blog.itpub.net/267265/viewspace-1399275/
http://blog.itpub.net/267265/viewspace-1399890/
http://blog.itpub.net/267265/viewspace-1404262/
--实际上要转储表空间位图信息,可以简单的执行:
SCOTT@test> @ver1
PORT_STRING VERSION BANNER
------------------------------ -------------- --------------------------------------------------------------------------------
x86_64/Linux 2.4.xx 11.2.0.3.0 Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
--必须以sys用户执行:
SYS@test> execute dbms_space_admin.tablespace_dump_bitmaps('USERS');
PL/SQL procedure successfully completed.
*** 2015-05-12 08:31:04.574
Header Control:
RelFno: 4, Unit: 8, Size: 131072, Flag: 9
AutoExtend: YES, Increment: 2048, MaxSize: 4194302
Initial Area: 126, Tail: 131071, First: 55, Free: 16195
Deallocation scn: 4100692185.2
Header Opcode:
Save: No Pending Op
File Space Bitmap Block:
BitMap Control:
RelFno: 4, BeginBlock: 128, Flag: 0, First: 55, Free: 63315
FFFFFFFFFFFF7FFE 0000000000000000 00000000FF1FFFFF FFFF00D0FF010000
0000000000000000 0000000000000000 0000000000000000 0000000000000000
0000000000000000 000000000000FC7F 0000000000000000 0000000000000000
0000000000000000 0000000000000000 0000000000000000 0000000000000000
0000000000000000 0000000000000000 0000000000000000 0000000000000000
0000000000000000 0000000000000000 0000000000000000 0000000000000000
0000000000000000 0000000000000000 0000000000007E00 00000000000000E0
0000000000000000 0000000000000000 0000000000000000 0000088000000000
0000000000000000 0000000000000000 0000000000000000 0000000000000000
0000000000000000 000000000000FEFF FF0F000000000000 0000000000000000
0000000000000000 0000000000000000 0000000000000000 0000000000000000
....
SYS@test> column PARTITION_NAME noprint
SYS@test> column SEGMENT_NAME format a30
SYS@test> select * from dba_extents where tablespace_name='USERS' order by block_id;
OWNER SEGMENT_NAME SEGMENT_TYPE TABLESPACE_NAME EXTENT_ID FILE_ID BLOCK_ID BYTES BLOCKS RELATIVE_FNO
------ ------------------------------ ------------------ ------------------------------ ---------- ---------- ---------- ---------- ---------- ------------
SCOTT PK_DEPT INDEX USERS 0 4 128 65536 8 4
SYS REPAIR_TABLE TABLE USERS 0 4 136 65536 8 4
SCOTT EMP TABLE USERS 0 4 144 65536 8 4
SCOTT PK_EMP_EMPNO INDEX USERS 0 4 152 65536 8 4
SCOTT T1 TABLE USERS 0 4 160 65536 8 4
OE ACTION_TABLE NESTED TABLE USERS 0 4 168 65536 8 4
OE SYS_LOB0000074466C00004$$ LOBSEGMENT USERS 0 4 176 65536 8 4
OE SYS_IL0000074466C00004$$ LOBINDEX USERS 0 4 184 65536 8 4
OE SYS_C0011033 INDEX USERS 0 4 192 65536 8 4
OE LINEITEM_TABLE NESTED TABLE USERS 0 4 200 65536 8 4
OE SYS_LOB0000074470C00005$$ LOBSEGMENT USERS 0 4 208 65536 8 4
OE SYS_IL0000074470C00005$$ LOBINDEX USERS 0 4 216 65536 8 4
OE SYS_LOB0000074470C00010$$ LOBSEGMENT USERS 0 4 224 65536 8 4
OE SYS_IL0000074470C00010$$ LOBINDEX USERS 0 4 232 65536 8 4
OE SYS_C0011034 INDEX USERS 0 4 240 65536 8 4
OE PURCHASEORDER TABLE USERS 0 4 248 65536 8 4
OE NAMESPACES567_L LOBSEGMENT USERS 0 4 256 65536 8 4
OE SYS_IL0000074465C00004$$ LOBINDEX USERS 0 4 264 65536 8 4
OE EXTRADATA566_L LOBSEGMENT USERS 0 4 272 65536 8 4
OE SYS_IL0000074465C00005$$ LOBINDEX USERS 0 4 280 65536 8 4
OE SYS_XDBPD$561_L LOBSEGMENT USERS 0 4 288 65536 8 4
OE SYS_IL0000074465C00008$$ LOBINDEX USERS 0 4 296 65536 8 4
OE SYS_XDBPD$562_L LOBSEGMENT USERS 0 4 304 65536 8 4
OE SYS_IL0000074465C00012$$ LOBINDEX USERS 0 4 312 65536 8 4
OE SYS_XDBPD$563_L LOBSEGMENT USERS 0 4 320 65536 8 4
OE SYS_IL0000074465C00017$$ LOBINDEX USERS 0 4 328 65536 8 4
OE SYS_XDBPD$564_L LOBSEGMENT USERS 0 4 336 65536 8 4
OE SYS_IL0000074465C00026$$ LOBINDEX USERS 0 4 344 65536 8 4
OE SYS_XDBPD$565_L LOBSEGMENT USERS 0 4 352 65536 8 4
OE SYS_IL0000074465C00033$$ LOBINDEX USERS 0 4 360 65536 8 4
OE LINEITEM_TABLE_MEMBERS INDEX USERS 0 4 368 65536 8 4
OE ACTION_TABLE_MEMBERS INDEX USERS 0 4 376 65536 8 4
OE SYS_C0011037 INDEX USERS 0 4 384 65536 8 4
OE LINEITEM_TABLE NESTED TABLE USERS 1 4 392 65536 8 4
OE LINEITEM_TABLE NESTED TABLE USERS 2 4 400 65536 8 4
OE SYS_C0011034 INDEX USERS 1 4 408 65536 8 4
OE LINEITEM_TABLE NESTED TABLE USERS 3 4 416 65536 8 4
OE PURCHASEORDER TABLE USERS 1 4 424 65536 8 4
OE LINEITEM_TABLE NESTED TABLE USERS 4 4 432 65536 8 4
OE LINEITEM_TABLE NESTED TABLE USERS 5 4 440 65536 8 4
OE PRODUCT_REF_LIST_NESTEDTAB NESTED TABLE USERS 0 4 448 65536 8 4
OE SYS_FK0000074515N00007$ INDEX USERS 0 4 456 65536 8 4
OE SUBCATEGORY_REF_LIST_NESTEDTAB NESTED TABLE USERS 0 4 464 65536 8 4
OE SYS_FK0000074515N00009$ INDEX USERS 0 4 472 65536 8 4
OE CATEGORIES_TAB TABLE USERS 0 4 480 65536 8 4
OE SYS_C0011038 INDEX USERS 0 4 488 65536 8 4
OE SYS_C0011039 INDEX USERS 0 4 496 65536 8 4
OE SYS_C0011040 INDEX USERS 0 4 504 65536 8 4
OE SYS_C0011041 INDEX USERS 0 4 512 65536 8 4
SCOTT TEMPERATURE TABLE USERS 0 4 520 65536 8 4
SCOTT T1 TABLE USERS 1 4 528 65536 8 4
SCOTT T1 TABLE USERS 2 4 536 65536 8 4
SCOTT CLUSTER_DEPT CLUSTER USERS 1 4 544 65536 8 4
SCOTT I_EMP_HIREDATE INDEX USERS 0 4 552 65536 8 4
SCOTT T1 TABLE USERS 3 4 560 65536 8 4
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
SCOTT Z1 TABLE USERS 0 4 584 65536 8 4
SCOTT Y1 TABLE USERS 0 4 592 65536 8 4
SCOTT Y2 TABLE USERS 0 4 600 65536 8 4
SCOTT T1 TABLE USERS 4 4 608 65536 8 4
SCOTT Y3 TABLE USERS 0 4 616 65536 8 4
SCOTT DEPARTMENTS TABLE USERS 0 4 624 65536 8 4
SCOTT T1 TABLE USERS 5 4 632 65536 8 4
SCOTT T1 TABLE USERS 6 4 1408 65536 8 4
SCOTT T2 TABLE USERS 0 4 1416 65536 8 4
....
OE ORDERS2 TABLE PARTITION USERS 0 4 19672 65536 8 4
SCOTT I_EMP_ENAME INDEX USERS 0 4 42616 65536 8 4
HR EMP_DEPARTMENT_ACS_IX INDEX USERS 0 4 57168 65536 8 4
SCOTT I_DEPT_DNAME INDEX USERS 0 4 57184 65536 8 4
143 rows selected.
--注意在在执行上面语句前,我清除了回收站.
--FFFFFFFFFFFF7FFE
--FFFFFFFF 一共12个F,1bits表示64K, 12*4=48
--剩下7FFE, intel系统做一个转换 FE7F => 1111 1110 0111 1111,前面48+7=55.
--可以发现56,57位置没有数据.注意看~位置,对上的.
