dump block

From: April Sims <sims_at_suu.edu>
Date: Fri, 23 Oct 2009 09:18:05 -0600
Message-Id: <4AE182D6.6F64.0018.0_at_suu.edu>

Please clarify if I am incorrect.....when using dump block, the first few blocks are header(s)? Older instructions I have talk about a single header block.  

I didn't see data until block 132.  

Any further clarification would be appreciated.  

thanks  

 select dbms_rowid.rowid_relative_fno(rowid) as filenumber,    dbms_rowid.rowid_block_number(rowid) as blocknumber     from tracking;
  2 3
FILENUMBER BLOCKNUMBER
---------- -----------

         4 132  

select file_id, block_id, segment_name, blocks, tablespace_name from   dba_extents where owner ='TTRACKER' and segment_type='TABLE';   2
   FILE_ID BLOCK_ID
---------- ----------

SEGMENT_NAME

---

    BLOCKS TABLESPACE_NAME
---------- ------------------------------

         4 128
TRACKING     Start dump data blocks tsn: 4 file#:4 minblk 128 maxblk 128 Block dump from cache:
Dump of buffer cache at level 4 for tsn=4, rdba=16777344 Block dump from disk:
buffer tsn: 4 rdba: 0x01000080 (4/128)
scn: 0x0000.000fc90f seq: 0x01 flg: 0x04 tail: 0xc90f2001 frmt: 0x02 chkval: 0xd3a9 type: 0x20=FIRST LEVEL BITMAP BLOCK  

Start dump data blocks tsn: 4 file#:4 minblk 129 maxblk 129 Block dump from cache:
Dump of buffer cache at level 4 for tsn=4, rdba=16777345 Block dump from disk:
buffer tsn: 4 rdba: 0x01000081 (4/129)
scn: 0x0000.000fc8f0 seq: 0x01 flg: 0x04 tail: 0xc8f02101 frmt: 0x02 chkval: 0x9366 type: 0x21=SECOND LEVEL BITMAP BLOCK  

Start dump data blocks tsn: 4 file#:4 minblk 130 maxblk 130 Block dump from cache:
Dump of buffer cache at level 4 for tsn=4, rdba=16777346   scn: 0x0000.000fc90f seq: 0x01 flg: 0x04 tail: 0xc90f2301   frmt: 0x02 chkval: 0xbe4a type: 0x23=PAGETABLE SEGMENT HEADER  

Start dump data blocks tsn: 4 file#:4 minblk 131 maxblk 131 Block dump from cache:
Dump of buffer cache at level 4 for tsn=4, rdba=16777347 Block dump from disk:
buffer tsn: 4 rdba: 0x01000083 (4/131)
scn: 0x0000.000fc90f seq: 0x01 flg: 0x04 tail: 0xc90f0601 frmt: 0x02 chkval: 0xc62d type: 0x06=trans data Start dump data blocks tsn: 4 file#:4 minblk 132 maxblk 132 Block dump from cache:
Dump of buffer cache at level 4 for tsn=4, rdba=16777348 Block dump from disk:
buffer tsn: 4 rdba: 0x01000084 (4/132)
scn: 0x0000.000fdaf2 seq: 0x01 flg: 0x04 tail: 0xdaf20601 frmt: 0x02 chkval: 0x81e5 type: 0x06=trans dataBlock header dump: 0x01000084  Object id on Block? Y

 seg/obj: 0x115cf  csc: 0x00.fd140  itc: 2  flg: E  typ: 1 - DATA
     brn: 0  bdba: 0x1000080 ver: 0x01 opc: 0
     inc: 0  exflg: 0
 
 Itl           Xid                  Uba         Flag  Lck        Scn/Fsc

0x01 0x000a.00a.000002bb 0x00c00116.00bf.33 C--- 0 scn 0x0000.000fc923 0x02 0x0004.000.000002b6 0x00c0046e.0090.1b C--- 0 scn 0x0000.000fd018 bdba: 0x01000084
data_block_dump,data header at 0x2b66b7d4fa64

---

tsiz: 0x1f98
hsiz: 0x14
pbl: 0x2b66b7d4fa64

     76543210

flag=--------
ntab=1
nrow=1
frre=-1
fsbo=0x14
fseo=0x1f79
avsp=0x1f70
tosp=0x1f70

0xe:pti[0] nrow=1 offs=0
0x12:pri[0] offs=0x1f79
block_row_dump:
tab 0, row 0, _at_0x1f79
tl: 20 fb: --H-FL-- lb: 0x0 cc: 3

col  0: [ 2]  c1 02
col  1: [ 4]  48 45 52 42
col  2: [ 8]  30 30 30 66 63 39 32 33

end_of_block_dump
End dump data blocks tsn: 4 file#: 4 minblk 132 maxblk 132                    

April Sims
SELECT IOUG Contributing Editor

http://aprilcsims.wordpress.com ( http://aprilcsims.wordpress.com/ ) 
http://www.twitter.com/aprilcsims 
http://www.twibes.com/lone_dba 
http://www.twibes.com/novicedba 

OCP 8i, 9i, 10g DBA
Southern Utah University
sims_at_suu.edu
940-484-4276

--

http://www.freelists.org/webpage/oracle-l Received on Fri Oct 23 2009 - 10:18:05 CDT