5和6 objbc oracle_dump ORACLE数据库内部结构-block | 学步园

我们有时分析数据，不得不进行block的分析，Oracle里多是用block作为数据单元的，

我们这里首先一起看看data block的分析

分析数据文件块，转储数据文件n的块m (dump a block to trc)

alter system dump datafile n block m

或者

alter system dump dafile n block min m1 block max m2;

例子

SQL>create table test2.dumptable_test (

name varchar2(4000),

txt1 varchar2(4000),

txt2 varchar2(4000),

txt3 varchar2(4000));

SQL>insert into test2.dumptable_test values(

‘aaaaaaaaaa’,'bbbbbbbbbb’,'cccccccccc’,'dddddddddd’);

SQL>insert into test2.dumptable_test values(

‘AAAAAAAAAA’,'BBBBBBBBBB’,'CCCCCCCCCC’,'DDDDDDDDDD’);

SQL>commit;

SQL> select gettracename() from dual;

GETTRACENAME()

——————————————————————————–

/opt/oracle/admin/ORCL203/udump/orcl203_ora_4408.trc

SQL> select header_file, header_block from dba_segments where upper(segment_name) = upper(’dumptable_test’);

HEADER_FILE HEADER_BLOCK

———– ————

5 899

SQL> alter system dump datafile 5 block 899;

$vi /opt/oracle/admin/ORCL203/udump/orcl203_ora_4408.trc

Repeat 151 times

C7BC040 00000000 00000000 01400382 00000000 [..........@.....]

C7BC050 00000000 00000000 00000000 00000000 [................]

Repeat 185 times

C7BCBF0 00000000 00000000 00000000 321C2302 [.............#.2]

Extent Control Header

—————————————————————–

Extent Header:: spare1: 0 spare2: 0 #extents: 1 #blocks: 8