查询块号：
SELECT segment_name,file_id,block_id FROM dba_extents WHERE owner='LYX' AND segment_name ='TEST';
或者 SELECT segment_name,header_file,header_block FROM DBA_segments WHERE segment_name='TEST';
得到如下结果：
| SEGMENT_NAME | FILE_ID | BLOCK_ID | |
| 1 | TEST | 5 | 9 |
/oracle/app/oracle/admin/db3/udump/db3_ora_4838.trc
Oracle Database 10g Enterprise Edition Release 10.2.0.2.0 - Production
With the Partitioning, OLAP and Data Mining options ORACLE_HOME = /oracle/app/oracle/product/10g/db_1
System name: Linux
Node name: vm3
Release: 2.6.9-55.EL
Version: #1 Fri Apr 20 16:35:59 EDT 2007
Machine: i686
Instance name: db3
Redo thread mounted by this instance: 1
Oracle process number: 15
Unix process pid: 4838, image: oracle@vm3 (TNS V1-V3)
*** 2012-05-03 15:08:09.424
*** SERVICE NAME:(SYS$USERS) 2012-05-03 15:08:09.423
*** SESSION ID:(159.25) 2012-05-03 15:08:09.423 Recovery target incarnation = 2, activation ID = 0 Influx buffer limit = 4740 (50% x 9481) Start recovery at thread 1 ckpt scn 539888 logseq 4 block 22867 *** 2012-05-03 15:08:09.445 Media Recovery add redo thread 1 *** 2012-05-03 15:08:09.452 Recovery of Online Redo Log: Thread 1 Group 3 Seq 4 Reading mem 0 *** 2012-05-03 15:08:09.465 Recovery of Online Redo Log: Thread 1 Group 1 Seq 5 Reading mem 0 File 5 (stop scn 539963) completed recovery at checkpoint scn 539963 ARCH: Connecting to console port...
-----
Redo read statistics for thread 1
-----
Read rate (ASYNC): 1305Kb in 0.27s => 4.72 Mb/sec Total physical reads: 4105Kb Longest record: 0Kb, moves: 0/49 (0%) Change moves: 2/4 (50%), moved: 0Mb Longest LWN: 5Kb, moves: 0/13 (0%), moved: 0Mb Last redo scn: 0x0000.00083d25 (539941)
----------------------------------------------
*** 2012-05-03 15:08:09.709
Media Recovery drop redo thread 1
KCBR: Number of read descriptors = 4096
KCBR: Influx buffers flushed = 2 times
KCBR: Reads = 0 reap (0 no-op, 0 one), 5 all
*** 2012-05-03 16:22:47.751
Start dump data blocks tsn: 6 file#: 5 minblk 9 maxblk 9
buffer tsn: 6 rdba: 0x01400009 (5/9)
scn: 0x0000.00083b31 seq: 0x02 flg: 0x04 tail: 0x3b312002
frmt: 0x02 chkval: 0x0e92 type: 0x20=FIRST LEVEL BITMAP BLOCK
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x0CCCB400 to 0x0CCCD400
CCCB400 0000A220 01400009 00083B31 04020000 [ .....@.1;......]
CCCB410 00000E92 00000000 00000000 00000000 [................]
CCCB420 00000000 00000000 00000000 00000000 [................]
Repeat 1 times
CCCB440 00000000 00000000 00000000 00000004 [................]
CCCB450 FFFFFFFF 00000000 00000003 00000008 [................]
CCCB460 00010001 00000000 00000000 00000000 [................]
CCCB470 00000005 00000003 4FA221AA 4FA221AA [.........!.O.!.O]
CCCB480 00000000 00000000 00000000 00000000 [................]
CCCB490 0140000A 00000000 00000000 00000008 [..@.............]
CCCB4A0 00000008 01400011 00000000 00000000 [......@.........]
CCCB4B0 00000000 00000005 00000000 00000001 [................]
CCCB4C0 0000C8E0 00000000 00000000 01400009 [..............@.]
CCCB4D0 00000008 00000000 00000000 00000000 [................]
CCCB4E0 00000000 00000000 00000000 00000000 [................]
Repeat 9 times
CCCB580 00000000 00000000 00000000 55551511 [..............UU]
CCCB590 00000000 00000000 00000000 00000000 [................]
Repeat 485 times
CCCD3F0 00000000 00000000 00000000 3B312002 [............. 1;]
Dump of First Level Bitmap Block
--------------------------------
nbits : 4 nranges: 1 parent dba: 0x0140000a poffset: 0
unformatted: 0 total: 8 first useful block: 3
owning instance : 1
instance ownership changed at 05/03/2012 14:11:54
Last successful Search 05/03/2012 14:11:54
Freeness Status: nf1 0 nf2 0 nf3 0 nf4 5
Extent Map Block Offset: 4294967295
First free datablock : 3
Bitmap block lock opcode 0
Locker xid: : 0x0000.000.00000000
Inc #: 0 Objd: 51424
HWM Flag: HWM Set
Highwater:: 0x01400011 ext#: 0 blk#: 8 ext size: 8
#blocks in seg. hdr's freelists: 0
#blocks below: 5 mapblk 0x00000000 offset: 0
--------------------------------------------------------