\u73af\u5883\uff1a
\nORACLE:
\nBANNER
\n—————————————————————-
\nOracle Database 10g Enterprise Edition Release 10.2.0.2.0 – Prod
\nPL\/SQL Release 10.2.0.2.0 – Production
\nCORE\u00a0\u00a0\u00a0 10.2.0.2.0\u00a0\u00a0\u00a0\u00a0\u00a0 Production
\nTNS for Linux: Version 10.2.0.2.0 – Production
\nNLSRTL Version 10.2.0.2.0 – Production<\/p>\n
OS\uff1a<\/p>\n
LSB Version:\u00a0\u00a0\u00a0 :core-3.1-ia32:core-3.1-noarch:graphics-3.1-ia32:graphics-3.1-noarch
\nDistributor ID: EnterpriseEnterpriseServer
\nDescription:\u00a0\u00a0\u00a0 Enterprise Linux Enterprise Linux Server release 5.4 (Carthage)
\nRelease:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5.4
\nCodename:\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Carthage
\n\u7814\u7a76Bitmap\u7d22\u5f15\u7684\u5b58\u50a8\u548c\u7279\u6027<\/p>\n
SQL> conn scott\/scott
\nConnected.
\nSQL> CREATE TABLE t –\u521b\u5efa\u4e00\u5f20\u6d4b\u8bd5\u8868
\n2\u00a0 (
\n3\u00a0 NAME VARCHAR2(20)
\n4\u00a0 );
\nTable created.<\/p>\n
SQL> CREATE BITMAP INDEX idx_b_name ON t(NAME); –\u521b\u5efa\u4e00\u4e2a\u6d4b\u8bd5\u7684\u7d22\u5f15<\/p>\n
Index created.
\nSQL> select sid from v$mystat where rownum<2;\u00a0 –\u67e5\u770b\u81ea\u5df1\u7684sid<\/p>\n
SID
\n———-
\n159<\/p>\n
–\u67e5\u770btrace\u7684\u6587\u4ef6\u6240\u5728
\nselect a.value||b.symbol||c.instance_name||’_ora_’||d.spid||’.trc’ trace_file from
\n(select value from v$parameter where name=’user_dump_dest’) a,
\n(select substr(value,-6,1) symbol from v$parameter where name=’user_dump_dest’) b,
\n(select instance_name from v$instance) c,
\n(select spid from v$session s,v$process p,v$mystat m where s.paddr=p.addr
\nand s.sid=m.sid and m.statistic#=0) d;<\/p>\n
TRACE_FILE
\n——————————————————————————–
\n\/u01\/app\/oracle\/admin\/orcl\/udump\/orcl_ora_9707.trc
\n\u67e5\u770b\u6587\u4ef6\u5185\u5bb9<\/p>\n
*** ACTION NAME:() 2015-03-03 08:25:59.728
\n*** MODULE NAME:(SQL*Plus) 2015-03-03 08:25:59.728
\n*** SERVICE NAME:(SYS$USERS) 2015-03-03 08:25:59.728
\n*** SESSION ID:(159.7) 2015-03-03 08:25:59.728
\n—– begin tree dump\u00a0\u00a0 \u8fd9\u4e2a\u662f\u7a7a\u7684\u65f6\u5019
\nleaf: 0x100018c 16777612 (0: nrow: 0 rrow: 0)
\n—– end tree dump
\n*** 2015-03-03 08:28:08.940
\n—– begin tree dump\u00a0\u00a0 insert into t values(‘U’); commit;
\nleaf: 0x100018c 16777612 (0: nrow: 1 rrow: 1)
\n—– end tree dump
\n*** 2015-03-03 08:29:20.359
\n—– begin tree dump insert into t values(‘c’); commit;
\nleaf: 0x100018c 16777612 (0: nrow: 2 rrow: 2)
\n—– end tree dump
\n*** 2015-03-03 08:30:09.053
\n—– begin tree dump \u53c8insert into t values(‘U’); commit;
\nleaf: 0x100018c 16777612 (0: nrow: 2 rrow: 2)
\n—– end tree dump
\n*** 2015-03-03 08:38:07.763
\n—– begin tree dump\u00a0 delete from t where name=’c’; commit;
\nleaf: 0x100018c 16777612 (0: nrow: 2 rrow: 1)
\n—– end tree dump
\n*** 2015-03-03 08:40:35.384
\n—– begin tree dump\u00a0 –insert into t select OBJECT_TYPE from user_objects;
\nleaf: 0x100018c 16777612 (0: nrow: 3 rrow: 3)
\n—– end tree dump<\/p>\n
—– begin tree dump\u00a0\u00a0 insert into t SELECT object_type FROM dba_objects; \/ commit;
\nbranch: 0x100018c 16777612 (0: nrow: 6, level: 1)
\nleaf: 0x1000190 16777616 (-1: nrow: 11 rrow: 11)
\nleaf: 0x100018f 16777615 (0: nrow: 2 rrow: 2)
\nleaf: 0x100018d 16777613 (1: nrow: 17 rrow: 17)
\nleaf: 0x100028c 16777868 (2: nrow: 3 rrow: 3)
\nleaf: 0x100018e 16777614 (3: nrow: 2 rrow: 2)
\nleaf: 0x100028d 16777869 (4: nrow: 11 rrow: 11)
\n—– end tree dump \u8fd9\u4e2a\u65f6\u5019\u53ef\u4ee5\u53d1\u73b0\u6574\u4e2a\u6811\u7684\u7ed3\u6784\u90fd\u53d1\u751f\u4e86\u53d8\u5316 \u4e0d\u518d\u662f\u5355\u7eaf\u53ea\u6709\u4e00\u4e2a\u53f6\u5b50\u8282\u70b9\u4e86<\/p>\n
\u4ed4\u7ec6\u89c2\u5bdf\u6700\u540e\u4e00\u6b21dump\u51fa\u6765\u7684\u7ed3\u6784 \u6211\u4eec\u53ef\u4ee5\u5f97\u51fa\u4ee5\u4e0b\u7ed3\u8bba
\n1.\u539f\u6765\u7684\u53f6\u5b50\u8282\u70b9\u53d1\u751f\u4e86\u5206\u88c2\u800c\u4e0d\u662f\u8fc1\u79fb\u3002\uff08b-tree\u4e5f\u662f\u4e00\u6837\uff09 \u6839\u8282\u70b9\u6c38\u8fdc\u4e0d\u4f1a\u53d8
\n2.\u53f6\u5b50\u8282\u70b9\u4ece-1\u5f00\u59cb\u7684\u987a\u5e8f\u4e0d\u4ee3\u8868\u5728\u6570\u636e\u6587\u4ef6\u4e0a\u4e5f\u662f\u8fde\u7eed\u7684\u5757<\/p>\n
\u89c2\u5bdf\u5012\u6570\u7b2c\u4e8c\u4e2a\u7684nrow=3 \u6211\u4eec\u53bb\u9a8c\u8bc1\u662f\u5426\u662f\u8fd9\u6837
\nSQL> select DISTINCT name from t;<\/p>\n
NAME
\n——————–
\nU
\nINDEX
\nTABLE<\/p>\n
\u7b2c\u4e00\u5217\u4e2d\u7684
\n1.branch\u8868\u793a\u5206\u652f\u8282\u70b9\uff08\u5305\u62ec\u6839\u8282\u70b9\uff09\uff0c
\n2.leaf\u5219\u8868\u793a\u53f6\u5b50\u8282\u70b9
\n\u7b2c\u4e8c\u5217\u8868\u793a\u5341\u516d\u8fdb\u5236\u8868\u793a\u7684\u8282\u70b9\u7684\u5730\u5740\uff1b
\n\u7b2c\u4e09\u5217\u8868\u793a\u5341\u8fdb\u5236\u8868\u793a\u7684\u8282\u70b9\u7684\u5730\u5740\uff1b
\n\u7b2c\u56db\u5217\u8868\u793a\u76f8\u5bf9\u4e8e\u524d\u4e00\u4e2a\u8282\u70b9\u7684\u4f4d\u7f6e\uff0c\u6839\u8282\u70b9\u4ece0\u5f00\u59cb\u8ba1\u7b97\uff0c\u5176\u4ed6\u5206\u652f\u8282\u70b9\u548c\u53f6\u5b50\u8282\u70b9\u4ece-1\u5f00\u59cb\u8ba1\u7b97\uff1b
\n\u7b2c\u4e94\u5217\u7684nrow\u8868\u793a\u5f53\u524d\u8282\u70b9\u4e2d\u6240\u542b\u6709\u7684\u7d22\u5f15\u6761\u76ee\u7684\u6570\u91cf\u3002\u6bd4\u5982\u6211\u4eec\u53ef\u4ee5\u770b\u5230\u542b\u6709\u7684nrow\u4e3a2\uff0c\u8868\u793a\u8282\u70b9\u4e2d\u542b\u67092\u4e2a\u7d22\u5f15\u6761\u76ee\uff0c
\n\u5206\u522b\u6307\u54112\u4e2a\u5206\u652f\u8282\u70b9
\n\u7b2c\u516d\u5217\u4e2d\u7684
\n1.rrow\u8868\u793a\u6709\u6548\u7684\u7d22\u5f15\u6761\u76ee\uff08\u56e0\u4e3a\u7d22\u5f15\u6761\u76ee\u5982\u679c\u88ab\u5220\u9664\uff0c\u4e0d\u4f1a\u7acb\u5373\u88ab\u6e05\u9664\u51fa\u7d22\u5f15\u5757\u4e2d\u3002
\n\u6240\u4ee5nrow\u51cfrrow\u7684\u6570\u91cf\u5c31\u8868\u793a\u5df2\u7ecf\u88ab\u5220\u9664\u7684\u7d22\u5f15\u6761\u76ee\u6570\u91cf\uff09\u7684\u6570\u91cf\uff0c
\n2.level\u8868\u793a\u5206\u652f\u8282\u70b9\u7684\u5c42\u7ea7\uff0c\u5bf9\u4e8e\u53f6\u5b50\u8282\u70b9\u6765\u8bf4level\u90fd\u662f0<\/p>\n
\u4ee5\u79cd\u65b9\u5f0f\u4ee5\u6811\u72b6\u5f62\u5f0f\u8f6c\u50a8\u6574\u4e2a\u7d22\u5f15\u3002\u540c\u65f6\uff0c\u6211\u4eec\u53ef\u4ee5\u8f6c\u50a8\u4e00\u4e2a\u7d22\u5f15\u8282\u70b9\u6765\u770b\u770b\u5176\u4e2d\u5b58\u653e\u4e86\u4e9b\u4ec0\u4e48<\/p>\n
\u4ece\u4e0a\u9762\u6211\u4eec\u53ef\u4ee5\u770b\u5230\u7d22\u5f15\u5757\uff08\u6839\uff09\u7684\u5730\u5740\u4e3a\uff1a16777612 .\u6211\u4eec\u5148\u5c06\u5176\u8f6c\u6362\u4e3a\u6587\u4ef6\u53f7\u4ee5\u53ca\u6570\u636e\u5757\u53f7<\/p>\n
select dbms_utility.data_block_address_file(16777615) “file”,dbms_utility.data_block_address_block(16777615) “BLOCK” from dual;<\/p>\n
FILE\u00a0 BLOCK
\n—————
\n4\u00a0\u00a0\u00a0\u00a0 396<\/p>\n
— \u6ce8\uff1a \u53cd\u63a8\u7684\u8bdd\u53ef\u4ee5\u4f7f\u7528\u00a0 select dbms_utility.make_data_block_address(4,396) from dual;
\n\u6211\u4eec\u9996\u5148\u770b\u4e00\u4e0b\u6839\u8282\u70b9 \u7136\u540e\u518d\u770b\u4e00\u4e0b\u53f6\u5b50\u8282\u70b9<\/p>\n
SQL> alter system dump datafile 4 block 396;<\/p>\n
System altered.
\n–\u5185\u5bb9\u5982\u4e0b<\/p>\n
*** 2015-03-03 09:03:48.908
\nStart dump data blocks tsn: 4 file#: 4 minblk 396 maxblk 396
\nbuffer tsn: 4 rdba: 0x0100018c (4\/396)
\nscn: 0x0000.000739b7 seq: 0x02 flg: 0x04 tail: 0x39b70602
\nfrmt: 0x02 chkval: 0x3905 type: 0x06=trans data
\nHex dump of block: st=0, typ_found=1
\nDump of memory from 0x0DECE400 to 0x0DED0400
\nDECE400 0000A206 0100018C 000739B7 04020000\u00a0 [………9……]
\nDECE410 00003905 00000002 0000CD53 000739B7\u00a0 [.9……S….9..]
\nDECE420 00000000 00320001 01000189 002C0006\u00a0 [……2…….,.]
\nDECE430 00000102 00800B8F 00020136 00008000\u00a0 [……..6…….]
\nDECE440 000739B7 00000000 00000000 04800001\u00a0 [.9…………..]
\nDECE450 00000001 00260005 1F171F3D 01000190\u00a0 [……&.=…….]
\nDECE460 00000004 00001F78 1F6C1F4B 1F5D1F44\u00a0 [….x…K.l.D.].]
\n\u3002\u3002\u3002
\n\u3002\u3002\u3002
\n\u7701\u7565\u90e8\u5206\u5185\u5bb9
\n\u3002\u3002\u3002
\n\u3002\u3002\u3002
\nBlock header dump:\u00a0 0x0100018c
\nObject id on Block? Y
\nseg\/obj: 0xcd53\u00a0 csc: 0x00.739b7\u00a0 itc: 1\u00a0 flg: E\u00a0 typ: 2 – INDEX
\nbrn: 0\u00a0 bdba: 0x1000189 ver: 0x01 opc: 0
\ninc: 0\u00a0 exflg: 0<\/p>\n
Itl\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Xid\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Uba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Flag\u00a0 Lck\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Scn\/Fsc
\n0x01\u00a0\u00a0 0x0006.02c.00000102\u00a0 0x00800b8f.0136.02\u00a0 C—\u00a0\u00a0\u00a0 0\u00a0 scn 0x0000.000739b7<\/p>\n
Branch block dump
\n=================
\nheader address 233628748=0xdece44c
\nkdxcolev 1
\nKDXCOLEV Flags = – – –
\nkdxcolok 0
\nkdxcoopc 0x80: opcode=0: iot flags=— is converted=Y
\nkdxconco 4
\nkdxcosdc 1
\nkdxconro 5
\nkdxcofbo 38=0x26
\nkdxcofeo 7997=0x1f3d
\nkdxcoavs 7959
\nkdxbrlmc 16777616=0x1000190
\nkdxbrsno 4
\nkdxbrbksz 8056
\nkdxbr2urrc 0
\nrow#0[8011] dba: 16777615=0x100018f
\ncol 0; len 10; (10):\u00a0 4a 41 56 41 20 43 4c 41 53 53
\ncol 1; len 1; (1):\u00a0 01
\ncol 2; TERM
\nrow#1[8044] dba: 16777613=0x100018d
\ncol 0; len 6; (6):\u00a0 4a 41 56 41 20 44
\ncol 1; TERM
\nrow#2[8004] dba: 16777868=0x100028c
\ncol 0; len 1; (1):\u00a0 53
\ncol 1; TERM
\nrow#3[8029] dba: 16777614=0x100018e
\ncol 0; len 7; (7):\u00a0 53 59 4e 4f 4e 59 4d
\ncol 1; len 1; (1):\u00a0 01
\ncol 2; TERM
\nrow#4[7997] dba: 16777869=0x100028d
\ncol 0; len 1; (1):\u00a0 54
\ncol 1; TERM
\n—– end of branch block dump —–
\nEnd dump data blocks tsn: 4 file#: 4 minblk 396 maxblk 396<\/p>\n
–kdxcolev\u8868\u793a\u7d22\u5f15\u5c42\u7ea7\u53f7\uff0c\u8fd9\u91cc\u7531\u4e8e\u6211\u4eec\u8f6c\u50a8\u7684\u662f\u6839\u8282\u70b9\u6240\u4ee5\u5176\u5c42\u7ea7\u53f7\u4e3a1\uff08\u5f53\u975e\u53f6\u5b50\u8282\u70b9\u65f6\u5c42\u7ea7\u4e5f\u6709\u53ef\u80fd\u4e3a2 3 4\u9012\u589e\uff09\u5bf9\u53f6\u5b50\u8282\u70b9\u6765\u8bf4\u8be5\u503c\u4e3a0
\n–kdxcolok\u8868\u793a\u8be5\u7d22\u5f15\u4e0a\u662f\u5426\u6b63\u5728\u53d1\u751f\u4fee\u6539\u5757\u7ed3\u6784\u7684\u4e8b\u52a1\uff1b
\n–kdxcoopc\u8868\u793a\u5185\u90e8\u64cd\u4f5c\u4ee3\u7801\uff1b
\n–kdxconco\u8868\u793a\u7d22\u5f15\u6761\u76ee\u4e2d\u5217\u7684\u6570\u91cf\uff1b
\n–kdxcosdc\u8868\u793a\u7d22\u5f15\u7ed3\u6784\u53d1\u751f\u53d8\u5316\u7684\u6570\u91cf\uff0c\u5f53\u4f60\u4fee\u6539\u8868\u91cc\u7684\u67d0\u4e2a\u7d22\u5f15\u952e\u503c\u65f6\uff0c\u8be5\u503c\u589e\u52a0\uff1b
\n–kdxconro\u8868\u793a\u5f53\u524d\u7d22\u5f15\u8282\u70b9\u4e2d\u7d22\u5f15\u6761\u76ee\u7684\u6570\u91cf\uff0c\u4f46\u662f\u6ce8\u610f\uff0c\u4e0d\u5305\u62eckdxbrlmc\u6307\u9488\uff1b
\n–kdxcofbo\u8868\u793a\u5f53\u524d\u7d22\u5f15\u8282\u70b9\u4e2d\u53ef\u7528\u7a7a\u95f4\u7684\u8d77\u59cb\u70b9\u76f8\u5bf9\u5f53\u524d\u5757\u7684\u4f4d\u79fb\u91cf\uff1b
\n–kdxcofeo\u8868\u793a\u5f53\u524d\u7d22\u5f15\u8282\u70b9\u4e2d\u53ef\u7528\u7a7a\u95f4\u7684\u6700\u5c3e\u7aef\u7684\u76f8\u5bf9\u5f53\u524d\u5757\u7684\u4f4d\u79fb\u91cf\uff1b
\n–kdxcoavs\u8868\u793a\u5f53\u524d\u7d22\u5f15\u5757\u4e2d\u7684\u53ef\u7528\u7a7a\u95f4\u603b\u91cf\uff0c\u4e5f\u5c31\u662f\u7528kdxcofeo\u51cf\u53bbkdxcofbo\u5f97\u5230\u7684\u3002
\n–kdxbrlmc\u8868\u793a\u5206\u652f\u8282\u70b9\u7684\u5730\u5740\uff0c\u8be5\u5206\u652f\u8282\u70b9\u5b58\u653e\u4e86\u7d22\u5f15\u952e\u503c\u5c0f\u4e8erow#0\uff08\u5728\u8f6c\u50a8\u6587\u6863\u540e\u534a\u90e8\u5206\u663e\u793a\uff09\u6240\u542b\u6709\u7684\u6700\u5c0f\u503c\u7684\u6240\u6709\u8282\u70b9\u4fe1\u606f\uff1b
\n–kdxbrsno\u8868\u793a\u6700\u540e\u4e00\u4e2a\u88ab\u4fee\u6539\u7684\u7d22\u5f15\u6761\u76ee\u53f7\uff0c\u8fd9\u91cc\u770b\u5230\u662f0\uff0c\u8868\u793a\u8be5\u7d22\u5f15\u662f\u65b0\u5efa\u7684\u7d22\u5f15\uff1b
\n–kdxbrbksz\u8868\u793a\u53ef\u7528\u6570\u636e\u5757\u7684\u7a7a\u95f4\u5927\u5c0f\u3002\u5b9e\u9645\u4ece\u8fd9\u91cc\u5df2\u7ecf\u53ef\u4ee5\u770b\u5230\uff0c\u5373\u4fbf\u662fPCTFREE\u8bbe\u7f6e\u4e3a0\uff0c\u4e5f\u4e0d\u80fd\u7528\u8db38192\u5b57\u8282\u3002
\n\u63a5\u4e0b\u53bb\u770b\u5230\u7684\u662frow#0\u7684\u5185\u5bb9
\n\u8fd9\u90e8\u5206\u5185\u5bb9\u5c31\u662f\u5728\u6839\u8282\u70b9\u4e2d\u6240\u8bb0\u5f55\u7684\u7d22\u5f15\u6761\u76ee\uff0c\u603b\u5171\u662f5\u4e2a[0-4]\u6761\u76ee\u3002\u518d\u52a0\u4e0akdxbrlmc\u6240\u6307\u5411\u7684\u7b2c\u4e00\u4e2a\u5206\u652f\u8282\u70b9\uff0c
\n\u6211\u4eec\u77e5\u9053\u8be5\u6839\u8282\u70b9\u4e2d\u603b\u5171\u5b58\u653e\u4e866\u4e2a\u5206\u652f\u8282\u70b9\u7684\u7d22\u5f15\u6761\u76ee \u4e5f\u5bf9\u5e94\u4e86\u6811\u5f62\u7ed3\u6784\u91ccnrow\u7684\u503c<\/p>\n
\u6bcf\u4e2a\u7d22\u5f15\u6761\u76ee\u90fd\u6307\u5411\u4e00\u4e2a\u5206\u652f\u8282\u70b9\u3002
\n\u5176\u4e2dcol 1\u8868\u793a\u6240\u94fe\u63a5\u7684\u5206\u652f\u8282\u70b9\u7684\u5730\u5740\uff0c\u8be5\u503c\u7ecf\u8fc7\u4e00\u5b9a\u7684\u8f6c\u6362\u4ee5\u540e\u5b9e\u9645\u5c31\u662frow#\u6240\u5728\u884c\u7684dba\u7684\u503c\u3002
\n\u5982\u679c\u6839\u8282\u70b9\u4e0b\u6ca1\u6709\u5176\u4ed6\u7684\u5206\u652f\u8282\u70b9\uff0c\u5219col 1\u4e3aTERM \u6bd4\u5982\u4e0a\u9762\u7684dba: 16777613=0x100018d\u7684col 1; TERM<\/p>\n
col 0\u8868\u793a\u8be5\u5206\u652f\u8282\u70b9\u6240\u94fe\u63a5\u7684\u6700\u5c0f\u952e\u503c\u3002\u5176\u8f6c\u6362\u65b9\u5f0f\u975e\u5e38\u590d\u6742 \u662f\u8981\u4ece\u5341\u516d\u8fdb\u5236\u8f6c\u6362\u4e3a\u5341\u8fdb\u5236
\n\u6211\u4eec\u53ef\u4ee5\u505a\u4e0b\u8bd5\u9a8c<\/p>\n
row#0[8011] dba: 16777615=0x100018f
\ncol 0; len 10; (10):\u00a0 4a 41 56 41 20 43 4c 41 53 53
\nSELECT to_number(‘4a’,’XX’) FROM dual; –74
\nSELECT to_number(’41’,’XX’) FROM dual;–65
\nSELECT to_number(’56’,’XX’) FROM dual;–86
\nSELECT to_number(’41’,’XX’) FROM dual;–65
\nSELECT to_number(’20’,’XX’) FROM dual;–32
\nSELECT to_number(’43’,’XX’) FROM dual;–67
\nSELECT to_number(‘4c’,’XX’) FROM dual;–76
\nSELECT to_number(’41’,’XX’) FROM dual;–65
\nSELECT to_number(’53’,’XX’) FROM dual;–83
\nSELECT to_number(’53’,’XX’) FROM dual;–83
\n\u7d22\u5f15\u952e\u503c\u662fchar\u7c7b\u578b\u7684\uff0c\u6240\u4ee5\u5bf9\u6bcf\u4e2a\u503c\u90fd\u8fd0\u7528chr\u51fd\u6570\u5c31\u53ef\u4ee5\u5f97\u5230\u88ab\u7d22\u5f15\u952e\u503c\u4e3a:
\nSELECT CHR(74) FROM dual;\u00a0 –J
\nSELECT CHR(65) FROM dual;\u00a0 –A
\nSELECT CHR(86) FROM dual;\u00a0 –V
\nSELECT CHR(65) FROM dual;\u00a0 –A
\nSELECT CHR(32) FROM dual;\u00a0 — (\u7a7a\u683c)
\nSELECT CHR(67) FROM dual;\u00a0 –C
\nSELECT CHR(76) FROM dual;\u00a0 –L
\nSELECT CHR(65) FROM dual;\u00a0 –A
\nSELECT CHR(83) FROM dual;\u00a0 –S
\nSELECT CHR(83) FROM dual;\u00a0 –S
\n–\u6211\u64e6 \u7adf\u7136\u662fJAVA CLASS \uff0c JAVA CLASS\u5c31\u662fdba\u4e3a16777615\u7684\u7d22\u5f15\u5757\u6240\u94fe\u63a5\u7684\u6700\u5c0f\u952e\u503c<\/p>\n
\u7136\u540e\u518ddump\u4e00\u4e0b\u770b\u5230\u7ed3\u679c\u5c31\u662f\u6211\u4eec\u8981\u768410\u8fdb\u5236\u8fd8\u6ca1\u8f6c\u621016\u8fdb\u5236\u7684\u503c
\nselect dump(‘JAVA CLASS’) from dual;
\nTyp=96 Len=10: 74,65,86,65,32,67,76,65,83,83<\/p>\n
\u90a3\u4e48\u6211\u4eec\u4e0a\u9762dump\u51fa\u6765\u4e86\u6839\u8282\u70b9 \u63a5\u4e0b\u6765\u7ee7\u7eeddump\u53f6\u5b50\u8282\u70b9\u00a0 \u6211\u4eec\u5c31dump\u521a\u521a\u768416777615\u8fd9\u4e2a\u5757\u5427\u3002<\/p>\n
select dbms_utility.data_block_address_file(16777615) “file”,dbms_utility.data_block_address_block(16777615) “BLOCK” from dual;
\nfile\u00a0\u00a0\u00a0\u00a0\u00a0 BLOCK
\n———- ———-
\n4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 399<\/p>\n
alter system dump datafile 4 block 399;
\n\u6587\u4ef6\u5982\u4e0b\uff1a
\n*** 2015-03-03 10:26:29.354
\nStart dump data blocks tsn: 4 file#: 4 minblk 399 maxblk 399
\nbuffer tsn: 4 rdba: 0x0100018f (4\/399)
\nscn: 0x0000.00073fd7 seq: 0x01 flg: 0x04 tail: 0x3fd70601
\nfrmt: 0x02 chkval: 0x0703 type: 0x06=trans data
\nHex dump of block: st=0, typ_found=1
\nDump of memory from 0x0DECE400 to 0x0DED0400
\nDECE400 0000A206 0100018F 00073FD7 04010000\u00a0 [………?……]
\nDECE410 00000703 00000002 0000CD53 00073FD7\u00a0 [……..S….?..]
\nDECE420 00000000 00320002 01000189 00080004\u00a0 [……2………]
\n…..
\nBlock header dump:\u00a0 0x0100018f
\nObject id on Block? Y
\nseg\/obj: 0xcd53\u00a0 csc: 0x00.73fd7\u00a0 itc: 2\u00a0 flg: E\u00a0 typ: 2 – INDEX
\nbrn: 0\u00a0 bdba: 0x1000189 ver: 0x01 opc: 0
\ninc: 0\u00a0 exflg: 0<\/p>\n
Itl\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Xid\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Uba\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Flag\u00a0 Lck\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 Scn\/Fsc
\n0x01\u00a0\u00a0 0x0004.008.000000d0\u00a0 0x00800041.009e.01\u00a0 CB–\u00a0\u00a0\u00a0 0\u00a0 scn 0x0000.000739b2
\n0x02\u00a0\u00a0 0x0001.009.000000db\u00a0 0x008002da.00be.09\u00a0 C—\u00a0\u00a0\u00a0 0\u00a0 scn 0x0000.000739ba<\/p>\n
Leaf block dump
\n===============
\nheader address 233628772=0xdece464
\nkdxcolev 0
\nKDXCOLEV Flags = – – –
\nkdxcolok 0
\nkdxcoopc 0x80: opcode=0: iot flags=— is converted=Y
\nkdxconco 4
\nkdxcosdc 1
\nkdxconro 2
\nkdxcofbo 40=0x28
\nkdxcofeo 2853=0xb25
\nkdxcoavs 3233
\nkdxlespl 0
\nkdxlende 0
\nkdxlenxt 16777613=0x100018d
\nkdxleprv 16777616=0x1000190
\nkdxledsz 0
\nkdxlebksz 8032
\nrow#0[3667] flag: ——, lock: 0, len=3945
\ncol 0; len 10; (10):\u00a0 4a 41 56 41 20 43 4c 41 53 53
\ncol 1; len 6; (6):\u00a0 01 00 01 db 00 b0
\n….
\nrow#1[2853] flag: ——, lock: 0, len=814
\ncol 0; len 10; (10):\u00a0 4a 41 56 41 20 43 4c 41 53 53
\ncol 1; len 6; (6):\u00a0 01 00 02 3e 01 00
\ncol 2; len 6; (6):\u00a0 01 00 02 80 01 4f
\ncol 3; len 785; (785):
\ncf 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55
\n55 55 ce 55 55 55 55 55 55 05 ff 18 55 55 55 55 55 55 55 55 cf 55 55 55 55
\n55 55 55 55 cf 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 cf 55 55
\n55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 ce
\n55 55 55 55 55 55 05 ff 18 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55
\n55 cf 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 cf 55 55 55 55 55
\n55 55 55 cf 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 ce 55 55 55
\n55 55 55 05 ff 18 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 cf 55
\n55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55
\nc9 55 05 ff 2d 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 cf 55 55
\n55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 cf
\n55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 ce 55 55 55 55 55 55 05
\nff 18 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 cf 55 55 55 55 55
\n55 55 55 cf 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 cf 55 55 55
\n55 55 55 55 55 cf 55 55 55 55 55 55 55 55 ce 55 55 55 55 55 55 05 ff 18 55
\n—– end of leaf block dump —–
\nEnd dump data blocks tsn: 4 file#: 4 minblk 399 maxblk 399<\/p>\n
\u53d1\u73b0\u5185\u5bb9\u4e0e\u6839\u8282\u70b9\u5b8c\u5168\u7c7b\u4f3c\uff0c\u53ea\u4e0d\u8fc7\u8be5\u7d22\u5f15\u5757\u4e2d\u6240\u5305\u542b\u7684\u7d22\u5f15\u6761\u76ee\uff08\u6307\u5411\u53f6\u5b50\u8282\u70b9\uff09\u7684\u6570\u91cf\u53ea\u6709\u4e24\u4e2a<\/p>\n
\u6211\u4eec\u518d\u62ff\u5176\u4e2d\u4e00\u4e2a\u53f6\u5b50\u6765\u5206\u6790\u4e00\u4e0b
\nrow#1[2853] flag: ——, lock: 0, len=814
\ncol 0; len 10; (10):\u00a0 4a 41 56 41 20 43 4c 41 53 53
\ncol 1; len 6; (6):\u00a0 01 00 02 3e 01 00
\ncol 2; len 6; (6):\u00a0 01 00 02 80 01 4f
\ncol 3; len 785; (785):
\ncf 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55 55 55 cf 55 55 55 55 55 55<\/p>\n
\u5176\u4e2dflag\u8868\u793a\u6807\u8bb0\uff0c\u6bd4\u5982\u5220\u9664\u6807\u8bb0\u7b49\uff1b
\n\u800clock\u8868\u793a\u9501\u5b9a\u4fe1\u606f\u3002col 0\u8868\u793a\u7d22\u5f15\u952e\u503c\uff0c\u5176\u7b97\u6cd5\u4e0e\u6211\u4eec\u5728\u524d\u9762\u4ecb\u7ecd\u5206\u652f\u8282\u70b9\u65f6\u6240\u8bf4\u7684\u7b97\u6cd5\u4e00\u81f4\u3002<\/p>\n
\u7ee7\u7eed\u8f6c\u5316\u8fdb\u5236\u540e\u4f7f\u7528chr
\n4a 41 56 41 20 43 4c 41 53 53
\n74 65 86 65 32 67 76 65 83 83
\nJ\u00a0 A\u00a0 V\u00a0 A\u00a0\u00a0\u00a0\u00a0 C\u00a0 L\u00a0 A\u00a0 S\u00a0 S<\/p>\n
col 1
\n\u5728b-tree\u7684\u65f6\u5019\u8868\u793arowid
\n\u5728bitmap\u7684\u65f6\u5019\u8868\u793arowid\u7684\u8d77\u59cb\u4f4d\u7f6e
\n01 00 01 db 00 b0
\n010001db00b0<\/p>\n
SELECT to_number(‘010001db00b0′,’xxxxxxxxxxxx’) FROM dual;
\nselect dbms_utility.data_block_address_file(to_number(‘010001DB’,’xxxxxxxxxxxx’)) “file”,
\ndbms_utility.data_block_address_block(to_number(‘010001DB’,’xxxxxxxxxxxx’)) “BLOCK” from dual;<\/p>\n
4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 475
\ncol 2
\n\u5728b-tree\u7684\u65f6\u5019\u6ca1\u6709
\n\u5728bitmap\u4e2d\u8868\u793arowid\u7684\u7ed3\u675f\u4f4d\u7f6e
\n01000280014f<\/p>\n
col3\u8868\u793a\u4f4d\u56fe\u7f16\u7801 \u5728b-tree\u91cc\u4e00\u6837\u4e5f\u6ca1\u6709
\nselect to_number(‘0180001c’,’xxxxxxxxxxxx’) from dual;<\/p>\n
\u4e2d\u95f4\u7684ca\u548c\u5f00\u5934\u7684cf\uff0c\u4e0d\u662f\u7d22\u5f15\u7684bitmap\uff0c\u800c\u662f\u7c7b\u4f3c\u6570\u636e\u5934\u4e4b\u7c7b\u7684\u4e1c\u897f\uff0c\u5177\u4f53\u6570\u503c\u4ee3\u8868\u4ec0\u4e48\u6211\u8fd8\u4e0d\u6e05\u695a\uff0c\u4e0d\u8fc7\u4f3c\u4e4e\u6bcf64\u4f4d\u5c31\u4f1a\u51fa\u73b0\u4e00\u4e2a\u6570\u636e\u5934
\nSELECT
\nsys.pkg_number_trans.f_hex_to_bin(’55’) as c2,
\nfrom dual;<\/p>\n
1010101<\/p>\n
\u5176\u4e2d\u4e0d\u8db38\u4f4d\u7684\u524d\u9762\u75280\u8865\u9f50
\n–\u8fde\u63a5\u8d77\u6765\u5168\u662f\u4e8c\u8fdb\u5236\u7684\u6570\u636e\u00a0 \u4e5f\u5c31\u4ee3\u8868\u4e86\u662f\u4e0d\u662fJAVA CLASS<\/p>\n
SELECT SYS.pkg_number_trans.f_oct_to_hex(‘01000280014f’) FROM dual;<\/p>\n
\u5728\u6570\u636e\u5f88\u5c11\u7684\u65f6\u5019\u5355\u4e00\u5757\u7684\u65f6\u5019\u5f88\u5bb9\u6613\u9a8c\u8bc1 \u4f46\u662f\u6570\u636e\u591a\u4e86\u4e4b\u540e\u600e\u4e48\u5728\u5757\u4e0e\u5757\u4e4b\u95f4\u8fdb\u884c<\/p>\n
\u6211\u4eec\u6765\u505a\u4e00\u4e2a\u5355\u4e00\u7684\u5427
\nDROP TABLE t1 PURGE;
\nCREATE TABLE t1
\n(
\nID NUMBER
\n);
\nINSERT INTO t1 VALUES(1);
\nINSERT INTO t1 VALUES(2);
\nINSERT INTO t1 VALUES(3);
\nINSERT INTO t1 VALUES(4);
\nINSERT INTO t1 VALUES(3);
\nINSERT INTO t1 VALUES(2);
\nINSERT INTO t1 VALUES(1);
\nCOMMIT;
\nselect dbms_rowid.rowid_relative_fno(rowid)file_id, dbms_rowid.rowid_block_number(rowid)block_id,
\ndbms_rowid.rowid_row_number(rowid) row# from t1;<\/p>\n
FILE_ID\u00a0\u00a0 BLOCK_ID\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 ROW#
\n———- ———- ———-
\n4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 664\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 0
\n4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 664\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 1
\n4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 664\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 2
\n4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 664\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 3
\n4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 664\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 4
\n4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 664\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 5
\n4\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 664\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0\u00a0 6<\/p>\n
\u5728\u540c\u4e00\u4e2a\u6570\u636e\u5757\u4e0a
\nalter session set events ‘10608 trace name context forever, level 10608’;<\/p>\n
CREATE BITMAP INDEX IDX_B_T1 ON T1(ID);<\/p>\n
alter session set events ‘10608 trace name context off’;<\/p>\n
10608\u4e8b\u4ef6\u7528\u6765\u8ddf\u8e2a\u521b\u5efabitmap\u7d22\u5f15\u7684\u8fc7\u7a0b<\/p>\n
\u5185\u5bb9\u5982\u4e0b\uff1a
\nqerbiARwo: bitmap size is 8168
\nqerbiIPI default pctfree=10
\nqerbiIPI length=0
\nqerbiAllocate pfree=127 space=8168
\nqerbiStart first start
\nqerbiRop: rid=01000298.0000, new=Y , key: (2):\u00a0 c1 02\u00a0\u00a0 –\u8868\u793a\u8fd9\u662f\u4e00\u4e2a\u65b0\u503c \u4ea7\u751f\u4e00\u4e2a\u7684\u65b0\u7684\u4f4d\u56fe\u8868\u793a
\nqerbiCmpSz notfound pctfree=10
\nqerbiCmpSz adjblksize=7351 length=0
\nqerbiRop keysize=4 maxbm=3529
\nkdibcoinit(b7ddb044): srid=01000298.0000
\nqerbiRop: rid=01000298.0001, new=Y , key: (2):\u00a0 c1 03
\nkdibcoinit(b7ddafc8): srid=01000298.0001
\nqerbiRop: rid=01000298.0002, new=Y , key: (2):\u00a0 c1 04
\nkdibcoinit(b7ddaf4c): srid=01000298.0002
\nqerbiRop: rid=01000298.0003, new=Y , key: (2):\u00a0 c1 05
\nkdibcoinit(b7ddaed0): srid=01000298.0003
\nqerbiRop: rid=01000298.0004, new=N, key: (2):\u00a0 c1 04\u00a0 –\u4e0d\u662f\u65b0\u503c
\nqerbiRop: rid=01000298.0005, new=N, key: (2):\u00a0 c1 03
\nqerbiRop: rid=01000298.0006, new=N, key: (2):\u00a0 c1 02
\nkdibcoend(b7ddb044): erid=01000298.0007status=3
\nqerbiCon: key: (2):\u00a0 c1 02
\nsrid=01000298.0 erid=01000298.7 bitmap: (2):\u00a0 c8 41
\nkdibcoend(b7ddafc8): erid=01000298.0007status=3
\nqerbiCon: key: (2):\u00a0 c1 03
\nsrid=01000298.0 erid=01000298.7 bitmap: (2):\u00a0 c8 22
\nkdibcoend(b7ddaf4c): erid=01000298.0007status=3
\nqerbiCon: key: (2):\u00a0 c1 04
\nsrid=01000298.0 erid=01000298.7 bitmap: (2):\u00a0 c8 14
\nkdibcoend(b7ddaed0): erid=01000298.0007status=3
\nqerbiCon: key: (2):\u00a0 c1 05
\nsrid=01000298.0 erid=01000298.7 bitmap: (1):\u00a0 03
\nqerbiFreeMemory: Work heap is used.<\/p>\n
\u4e0a\u9762\u662f\u521b\u5efabitmap\u7d22\u5f15\u7684\u8fc7\u7a0b\u3002\u6211\u4eec\u5148\u628a\u88ab\u7d22\u5f15\u7684\u5217\u7684\u503c\u6362\u7b97\u6210\u5341\u516d\u8fdb\u5236\uff1a<\/p>\n
select dump(4),dump(3),dump(2),dump(1) from dual;
\nTyp=96 Len=2: 85,99\u00a0Typ=96 Len=3: 74,109,104
\n1\u00a0Typ=2 Len=2: 193,5\u00a0Typ=2 Len=2: 193,4\u00a0Typ=2 Len=2: 193,3\u00a0Typ=2 Len=2: 193,2
\n5 4 3 2\u768416\u8fdb\u5236\u662f05 04 03 02 \u540c\u65f6\u5bf9\u5e94\u4e86\u4e0a\u9762\u7684\u751f\u6210key\u90e8\u5206\u7684\u503c
\nqerbiCon: key: (2):\u00a0 c1 02
\nsrid=01000298.0 erid=01000298.7 bitmap: (2):\u00a0 c8 41\u00a0\u00a0\u00a0 \u4ece\u4e0a\u9762\u7684\u63a8\u8bba\u6211\u4eec\u5f97\u51fa02\u8868\u793a1
\nstart rowid\u548cend rowid\u7684\u683c\u5f0f\u5206\u4e24\u90e8\u5206\uff0c\u4e2d\u95f4\u7528\u70b9\u9694\u5f00\uff0c
\n\u70b9\u5de6\u8fb9\u7684\u8868\u793a\u6587\u4ef6\u53f7\uff08\u4ece\u5de6\u8fb9\u7b2c\u4e00\u4e2a\u5b57\u8282\u5f00\u59cb\u76844\u4e2a\u5b57\u8282\u8868\u793a\uff09\u548c\u6570\u636e\u5757\u53f7\uff08\u4ece\u5de6\u8fb9\u7b2c\u4e94\u4e2a\u5b57\u8282\u5f00\u59cb\u76844\u4e2a\u5b57\u8282\u8868\u793a\uff09\uff0c
\n\u70b9\u53f3\u8fb9\u8868\u793a\u6570\u636e\u5757\u91cc\u7684\u884c\u53f7\u3002\u8fd9\u91cc\u7684\u663e\u793a\u53ef\u4ee5\u770b\u5230\uff0c
\n\u8fd9\u51e0\u6761\u8bb0\u5f55\u90fd\u4f4d\u4e8e\u76f8\u540c\u7684\u6570\u636e\u5757\u91cc\u3002\u8fd9\u91cc\u76840100\u8868\u793a\u6587\u4ef6\u53f7
\nselect dbms_utility.data_block_address_file(to_number(‘01000298′,’xxxxxxxxxxxx’)) “file”,
\ndbms_utility.data_block_address_block(to_number(‘01000298′,’xxxxxxxxxxxx’)) “BLOCK” from dual;<\/p>\n
4\u00a0664
\n\u6839\u636e\u6211\u4eec\u521a\u521a\u7684\u63d2\u5165\u6309\u7167\u9884\u60f3\u7684\u5e94\u8be5\u662f\uff1a1000001<\/p>\n
\u5f97\u5230\u7ed3\u679c\u679c\u7136\u662f\uff1a
\nSELECT
\nsys.pkg_number_trans.f_hex_to_bin(’41’) as c2
\nfrom dual;
\n1000001<\/p>\n","protected":false},"excerpt":{"rendered":"
\u73af\u5883\uff1a ORACLE: BANNER —————& […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[6],"tags":[34,8],"class_list":["post-496","post","type-post","status-publish","format-standard","hentry","category-oracle","tag-oracle","tag-performance"],"_links":{"self":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/496","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=496"}],"version-history":[{"count":1,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/496\/revisions"}],"predecessor-version":[{"id":1004,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=\/wp\/v2\/posts\/496\/revisions\/1004"}],"wp:attachment":[{"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=496"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=496"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.royalwzy.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=496"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}