0x01400045 Free: 1 Inst: 1
0x01400058 Free: 1 Inst: 1
0x01400059 Free: 1 Inst: 1
0x0140006c Free: 1 Inst: 1
0x0140006d Free: 1 Inst: 1
0x01400080 Free: 1 Inst: 1
0x014000bc Free: 1 Inst: 1
0x014000f8 Free: 5 Inst: 1
--------------------------------------------------------
End dump data blocks tsn: 6 file#: 5 minblk 10 maxblk 10
该块为二级位图块,其中包含了每个一级块信息。父指针指向了0b也就是第11个块(三级位图块)
查看第11块信息:
oracle@oracle-one ~]$ sqlplus / as sysdba
SQL*Plus: Release 11.2.0.4.0 Production on Mon Dec 16 21:13:53 2013
Copyright (c) 1982, 2013, Oracle. All rights reserved.
Connected to:
Oracle Database 11g Enterprise Edition Release 11.2.0.4.0 - 64bit Production
With the Partitioning, Automatic Storage Management, OLAP, Data Mining
and Real Application Testing options
SQL> set linesize 200
SQL> col name for a20
SQL> col value for a70
SQL> alter system dump datafile 5 block 11;
System altered.
SQL> select * from v$diag_info;
INST_ID NAME VALUE
---------- -------------------- ----------------------------------------------------------------------
1 Diag Enabled TRUE
1 ADR Base /opt/app/oracle
1 ADR Home /opt/app/oracle/diag/rdbms/rhys/RHYS
1 Diag Trace /opt/app/oracle/diag/rdbms/rhys/RHYS/trace
1 Diag Alert /opt/app/oracle/diag/rdbms/rhys/RHYS/alert
1 Diag Incident /opt/app/oracle/diag/rdbms/rhys/RHYS/incident
1 Diag Cdump /opt/app/oracle/diag/rdbms/rhys/RHYS/cdump
1 Health Monitor /opt/app/oracle/diag/rdbms/rhys/RHYS/hm
1 Default Trace File /opt/app/oracle/diag/rdbms/rhys/RHYS/trace/RHYS_ora_3583.trc
1 Active Problem Count 0
1 Active Incident Coun 0
INST_ID NAME VALUE
---------- -------------------- ----------------------------------------------------------------------
t
11 rows selected.
SQL>
Start dump data blocks tsn: 6 file#:5 minblk 11 maxblk 11
Block dump from cache:
Dump of buffer cache at level 4 for tsn=6 rdba=20971531
BH (0x7bbf6748) file#: 5 rdba: 0x0140000b (5/11) class: 4 ba: 0x7bb56000
set: 3 pool: 3 bsz: 8192 bsi: 0 sflg: 1 pwc: 0,25
dbwrid: 0 obj: 87521 objn: 87521 tsn: 6 afn: 5 hint: f
hash: [0x83e16550,0x83e16550] lru: [0x7bbf6970,0x7bbf6700]
lru-flags: hot_buffer
ckptq: [NULL] fileq: [NULL] objq: [0x7bbf6728,0x73bf3ef0] objaq: [0x80b5d9d8,0x7bbf6738]
st: XCURRENT md: NULL fpin: 'ktswh03: ktscts' tch: 26
flags: block_written_once redo_since_read
LRBA: [0x0.0.0] LSCN: [0x0.0] HSCN: [0xffff.ffffffff] HSUB: [1]
Block dump from disk:
buffer tsn: 6 rdba: 0x0140000b (5/11)
scn: 0x0000.00160e8d seq: 0x02 flg: 0x04 tail: 0x0e8d2302
frmt: 0x02 chkval: 0xffa2 type: 0x23=PAGETABLE SEGMENT HEADER
Hex dump of block: st=0, typ_found=1
Dump of memory from 0x00007FE375257A00 to 0x00007FE375259A00
7FE375257A00 0000A223 0140000B 00160E8D 04020000 [#.....@.........]
7FE375257A10 0000FFA2 00000000 00000000 00000000 [................]
7FE375257A20 00000000 00000011 00000154 00000A9C [........T.......]
7FE375257A30 00000010 00000014 00000014 0140015C [............\.@.]
7FE375257A40 00000000 00000010 00000000 00000142 [............B...]
7FE375257A50 00000000 00000000 00000000 00000001 [................]
7FE375257A60 00000010 00000014 0140002C 00000000 [........,.@.....]
7FE375257A70 00000001 00000000 00000022 0140001C [........".....@.]
7FE375257A80 01400134 00000000 00000000 00000000 [4.@.............]
7FE375257A90 00000000 00000000 00000000 00000000 [................]
Repeat 3 times
7FE375257AD0 00000001 00002000 00000000 00001434 [..... ......4...]
7FE