Re: dump block

From: Tanel Poder <tanel_at_poderc.com>
Date: Fri, 23 Oct 2009 23:23:17 +0800
Message-ID: <4602f23c0910230823n5acd7a30n659dba4d3993376f_at_mail.gmail.com>

There are few blocks before segment header in the beginning of first extent which hold ASSM bitmaps (the FIRST/SECOND LEVEL BITMAP BLOCK in block dumps).

I've illustrated some things here:

http://www.tanelpoder.com/files/Poder_Freelists_vs_ASSM.ppt

--
Tanel Poder
http://blog.tanelpoder.com


On Fri, Oct 23, 2009 at 11:18 PM, April Sims <sims_at_suu.edu> wrote:



>  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

>

>

>

>


--
http://www.freelists.org/webpage/oracle-l

Received on Fri Oct 23 2009 - 10:23:17 CDT