Re: dump block
- From: Tanel Poder <tanel@xxxxxxxxxx>
- To: sims@xxxxxxx
- Date: Fri, 23 Oct 2009 23:23:17 +0800
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@xxxxxxx> 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
>
>
>
>
Other related posts:
- » dump block- April Sims
- » Re: dump block - Tanel Poder
