create table dxmy (id number,name varchar2(100));
insert into dxmy values(1,'dxmy');
insert into dxmy values(2,'dxmy');
insert into dxmy values(3,'dxmy');
insert into dxmy values(4,'dxmy');
commit;
SQL> select extent_id, file_id, block_id, blocks from dba_extents where segment_name = 'DXMY' order by extent_id;
SQL>
EXTENT_IDFILE_IDBLOCK_IDBLOCKS
---------- ---------- ---------- ----------
044568SQL> alter system dump datafile 4 block 456;
System altered
SQL> show parameter user
NAMETYPEVALUE
------------------------------------ ----------- ------------------------------
license_max_usersinteger0
parallel_adaptive_multi_userbooleanTRUE
redo_transport_userstring
user_dump_deststringD:\app\liming\diag\rdbms\orcl\orcl\trace【Oracle实验|dump文件的初体验】生成的dump文件简单示例：
Trace file D:\APP\LIMING\diag\rdbms\orcl\orcl\trace\orcl_ora_7708.trc
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, OLAP, Data Mining and Real Application Testing options
Windows NT Version V6.2
CPU: 4 - type 8664, 2 Physical Cores
Process Affinity: 0x0x0000000000000000
Memory (Avail/Total): Ph:11222M/16118M, Ph+PgF:8045M/17142M
Instance name: orcl
Redo thread mounted by this instance: 1
Oracle process number: 30
Windows thread id: 7708, image: ORACLE.EXE (SHAD)*** 2016-06-23 10:39:31.117
*** SESSION ID:(1144.569) 2016-06-23 10:39:31.117
*** CLIENT ID:() 2016-06-23 10:39:31.117
*** SERVICE NAME:(orcl) 2016-06-23 10:39:31.117
*** MODULE NAME:(PL/SQL Developer) 2016-06-23 10:39:31.117
*** ACTION NAME:(Command Window - New) 2016-06-23 10:39:31.117
Start dump data blocks tsn: 4 file#:4 minblk 456 maxblk 456
Block dump from cache:
Dump of buffer cache at level 4 for tsn=4 rdba=16777672
BH (0x00007FFEBEFB2018) file#: 4 rdba: 0x010001c8 (4/456) class: 8 ba: 0x00007FFEBE802000
set: 10 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 188,28
dbwrid: 0 obj: 88017 objn: 88017 tsn: 4 afn: 4 hint: f
hash: [0x00007FFEC8FC85E8,0x00007FFEF933C020] lru: [0x00007FFEBEFB2240,0x00007FFEBEFB1FD0]
ckptq: [NULL] fileq: [NULL] objq: [0x00007FFEEEFB8940,0x00007FFEBEFB1EC0] objaq: [0x00007FFEEEFB8930,0x00007FFEBEFB1ED0]
st: XCURRENT md: NULL fpin: 'ktspfwh6: ktspffbmb' tch: 1
flags: block_written_once redo_since_read
LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [3]
BH (0x00007FFEC8FC8530) file#: 4 rdba: 0x010001c8 (4/456) class: 8 ba: 0x00007FFEC8A4C000
set: 12 pool: 3 bsz: 8192 bsi: 0 sflg: 2 pwc: 201,28
dbwrid: 0 obj: 88005 objn: 88005 tsn: 4 afn: 4 hint: f
hash: [0x00007FFEF933C020,0x00007FFEBEFB20D0] lru: [0x00007FFECAF798B8,0x00007FFEC8FC7C60]
lru-flags: on_auxiliary_list
ckptq: [NULL] fileq: [NULL] objq: [NULL] objaq: [NULL]
st: FREE md: NULL fpin: 'ktspfwh6: ktspffbmb' tch: 0 lfb: 33
flags:
Block dump from disk:
buffer tsn: 4 rdba: 0x010001c8 (4/456)
scn: 0x0000.0024c385 seq: 0x02 flg: 0x04 tail: 0xc3852002
frmt: 0x02 chkval: 0xf07d type: 0x20=FIRST LEVEL BITMAP BLOCK
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00000000174F4400 to 0x00000000174F6400
0174F4400 0000A220 010001C8 0024C385 04020000[ .........$.....]
0174F4410 0000F07D 00000000 00000000 00000000[}...............]
0174F4420 00000000 00000000 00000000 00000000[................]
Repeat 1 times
0174F4440 00000000 00000000 00000000 00000004[................]
0174F4450 FFFFFFFF 00000000 00000003 00000008[................]
0174F4460 00010001 00000000 00000000 00000000[................]
0174F4470 00000005 00000003 576B463B 576B463B[........;
FkW;
FkW]
0174F4480 00000000 00000000 00000000 00000000[................]
0174F4490 010001C9 00000000 00000000 00000008[................]
0174F44A0 00000008 010001D0 00000000 00000000[................]
0174F44B0 00000000 00000005 00000000 00000001[................]
0174F44C0 000157D1 002461D5 00000000 010001C8[.W...a$.........]
0174F44D0 00000008 00000000 00000000 00000000[................]
0174F44E0 00000000 00000000 00000000 00000000[................]
Repeat 9 times
0174F4580 00000000 00000000 00000000 55551511[..............UU]
0174F4590 00000000 00000000 00000000 00000000[................]
Repeat 485 times
0174F63F0 00000000 00000000 00000000 C3852002[............. ..]
Dump of First Level Bitmap Block
--------------------------------
nbits : 4 nranges: 1parent dba:0x010001c9poffset: 0
unformatted: 0total: 8first useful block: 3
owning instance : 1
instance ownership changed at 06/23/2016 10:15:23
Last successful Search 06/23/2016 10:15:23
Freeness Status:nf1 0nf2 0nf3 0nf4 5
Extent Map Block Offset: 4294967295
First free datablock : 3
Bitmap block lock opcode 0
Locker xid::0x0000.000.00000000
Dealloc scn: 2384341.0
Flag: 0x00000001 (-/-/-/-/-/HWM)
Inc #: 0 Objd: 88017
HWM Flag: HWM Set
Highwater::0x010001d0ext#: 0blk#: 8ext size: 8
#blocks in seg. hdr's freelists: 0
#blocks below: 5
mapblk0x00000000offset: 0
--------------------------------------------------------
DBA Ranges :
--------------------------------------------------------
0x010001c8Length: 8Offset: 00:Metadata1:Metadata2:Metadata3:75-100% free
4:75-100% free5:75-100% free6:75-100% free7:75-100% free
--------------------------------------------------------
End dump data blocks tsn: 4 file#: 4 minblk 456 maxblk 456
