从数据块中读取记录
时间：2010-08-10 来源：hxl
1.得到文件号和块号
Select Dbms_Rowid.Rowid_Relative_Fno(Rowid) fno,
Dbms_Rowid.Rowid_Block_Number(Rowid) blkno,
Dbms_Rowid.rowid_row_number(Rowid) rowno
From Kr_Mail_Action_Day a
2.ALTER SYSTEM DUMP DATAFILE 4 BLOCK 516
3.得到trace部分内容:
block_row_dump:
tab 0, row 0, @0x1f7d
tl: 27 fb: --H-FL-- lb: 0x1 cc: 7 类型 具体值
col 0: [ 7] 78 6e 07 14 01 01 01 date 2010-7-20 declare dt date; begin dbms_stats.convert_raw_value(hextoraw('786e0714010101'),dt); dbms_output.put_line(to_char(dt,'yyyy-mm-dd hh24:mi:ss')); end;
col 1: [ 2] 30 31 varchar2 '01'
col 2: [ 2] c1 0b number 10 utl_raw.cast_to_number('c10b')
col 3: [ 2] c1 07 number 6 utl_raw.cast_to_number('c107')
col 4: [ 2] c1 07 number 6 utl_raw.cast_to_number('c107')
col 5: [ 1] 80 number 0 utl_raw.cast_to_number('80')
col 6: [ 1] 80 number 6 utl_raw.cast_to_number('80')
Select Dbms_Rowid.Rowid_Relative_Fno(Rowid) fno,
Dbms_Rowid.Rowid_Block_Number(Rowid) blkno,
Dbms_Rowid.rowid_row_number(Rowid) rowno
From Kr_Mail_Action_Day a
2.ALTER SYSTEM DUMP DATAFILE 4 BLOCK 516
3.得到trace部分内容:
block_row_dump:
tab 0, row 0, @0x1f7d
tl: 27 fb: --H-FL-- lb: 0x1 cc: 7 类型 具体值
col 0: [ 7] 78 6e 07 14 01 01 01 date 2010-7-20 declare dt date; begin dbms_stats.convert_raw_value(hextoraw('786e0714010101'),dt); dbms_output.put_line(to_char(dt,'yyyy-mm-dd hh24:mi:ss')); end;
col 1: [ 2] 30 31 varchar2 '01'
col 2: [ 2] c1 0b number 10 utl_raw.cast_to_number('c10b')
col 3: [ 2] c1 07 number 6 utl_raw.cast_to_number('c107')
col 4: [ 2] c1 07 number 6 utl_raw.cast_to_number('c107')
col 5: [ 1] 80 number 0 utl_raw.cast_to_number('80')
col 6: [ 1] 80 number 6 utl_raw.cast_to_number('80')
相关阅读 更多 +
