[20150512]轉儲表空間位圖資訊.txt
--曾經在探究系統管理表空間位圖區分布存在許多疑問,參考如下連結:
<a href="http://blog.itpub.net/267265/viewspace-1399275/">http://blog.itpub.net/267265/viewspace-1399275/</a>
<a href="http://blog.itpub.net/267265/viewspace-1399890/">http://blog.itpub.net/267265/viewspace-1399890/</a>
<a href="http://blog.itpub.net/267265/viewspace-1404262/">http://blog.itpub.net/267265/viewspace-1404262/</a>
--實際上要轉儲表空間位圖資訊,可以簡單的執行:
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 0000000000007E00 00000000000000E0
0000000000000000 0000000000000000 0000000000000000 0000088000000000
0000000000000000 000000000000FEFF FF0F000000000000 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位置沒有資料.注意看~位置,對上的.