手工提交Cluster Table的事务

本站文章除注明转载外，均为本站原创： 转载自love wife love life —Roger 的Oracle技术博客 本文链接地址: 手工提交Cluster Table的事务 前几天培训班中有学生问到,对于cluster table如果去实现手工提交事务,来屏蔽一些错误.他在自己的 环境中遇到了ora-00

本站文章除注明转载外，均为本站原创： 转载自love wife & love life —Roger 的Oracle技术博客

本文链接地址: 手工提交Cluster Table的事务

前几天培训班中有学生问到,对于cluster table如果去实现手工提交事务,来屏蔽一些错误.他在自己的
环境中遇到了ora-00600 4000错误,涉及的对象即为cluster table,下面我这里简单模拟了一下。供参考!

++++创建测试表

SQL> conn roger/rogerConnected.SQL> create cluster t_cluster(id number(2)) ;Cluster created.SQL> create table t_0610 2  (id number(2) primary key, 3  name varchar2(13)) 4  cluster t_cluster(id);Table created.SQL>  create index t_cluster_idx on cluster t_cluster;Index created.SQL>SQL> insert into t_0610 values(1,'baidu');1 row created.SQL> insert into t_0610 values(2,'google');1 row created.SQL> insert into t_0610 values(8,'roger');1 row created.SQL> commit;Commit complete.SQL> select * from t_0610;ID NAME---------- ------------- 1 baidu 2 google 8 rogerSQL> select dbms_rowid.rowid_relative_fno(rowid) file#,dbms_rowid.rowid_block_number(rowid) blk# 2  from t_0610;FILE#       BLK#---------- ---------- 6        172 6        173 6        174SQL> oradebug setmypidORA-01031: insufficient privilegesSQL> conn /as sysdbaConnected.SQL> oradebug setmypidStatement processed.SQL> alter system flush buffer_cache;System altered.SQL> alter system dump datafile 6 block 172;System altered.SQL> oradebug close_traceStatement processed.SQL> oradebug tracefile_name/oracle/diag/rdbms/roger/roger/trace/roger_ora_16777.trc

++++blockdump内容

Dump of buffer cache at level 4 for tsn=7 rdba=25165996BH (0x71bf2f28) file#: 6 rdba: 0x018000ac (6/172) class: 1 ba: 0x71ad8000 set: 3 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 0,15 dbwrid: 0 obj: 77519 objn: 77520 tsn: 7 afn: 6 hint: f hash: [0x8abfa738,0x8abfa738] lru: [0x74ff33a0,0x7abf47d0] lru-flags: on_auxiliary_list ckptq: [NULL] fileq: [NULL] objq: [NULL] objaq: [NULL] st: FREE md: NULL fpin: 'ktspbwh2: ktspfmdb' tch: 0 lfb: 33 flags:Block dump from disk:buffer tsn: 7 rdba: 0x018000ac (6/172)scn: 0x0000.00b941a6 seq: 0x01 flg: 0x06 tail: 0x41a60601frmt: 0x02 chkval: 0xcb52 type: 0x06=trans dataHex dump of block: st=0, typ_found=1Dump of memory from 0x00007FADB771EA00 to 0x00007FADB7720A007FADB771EA00 0000A206 018000AC 00B9<i style="color:transparent">本文来源gaodai$ma#com搞$代*码*网(</i>41A6 06010000  [.........A......]7FADB771EA10 0000CB52 00000001 00012ECF 00B94199  [R............A..]7FADB771EA20 00000000 00320002 018000A8 00080006  [......2.........]7FADB771EA30 00000515 00C00562 002E014E 00008000  [....b...N.......]7FADB771EA40 00B94198 001D0007 000004C9 00C03C08  [.A........... 大于2，说明这是一个cluster tablenrow=2frre=-1fsbo=0x1afseo=0x1f78avsp=0x1f5etosp=0x1f5e0xe:pti[0]      nrow=1  offs=00x12:pti[1]     nrow=1  offs=10x16:pri[0]     offs=0x1f820x18:pri[1]     offs=0x1f78block_row_dump:tab 0, row 0, @0x1f82tl: 22 fb: K-H-FL-- lb: 0x0  cc: 1curc: 1 comc: 1 pk: 0x018000ac.0 nk: 0x018000ac.0col  0: [ 2]  c1 02tab 1, row 0, @0x1f78tl: 10 fb: -CH-FL-- lb: 0x2  cc: 1 cki: 0col  0: [ 5]  62 61 69 64 75end_of_block_dumpEnd dump data blocks tsn: 7 file#: 6 minblk 172 maxblk 172

喜欢 (0)赏

[搞代码]

分享 (0)